Forum Discussion
Quick Measure - Time Intelligence - my own date table
I am using my own date table in Power BI and have run into a strange problem. I've succesfully created a number of time intelligence quick measures to show month-over-month, quarter-over-quarter, and YTD changes. However, when trying to create a Rolling Average measure I run into the "Only Power BI-provided date hierarchies are supported". I didn't get this for the other time intelligence measures so what's the reason now? Has anyone solved this issue without having to write DAX code?
Many thanks,
Kevin
Hi KevinGraham,
The quick measures feature only works on very simple data models ( a single table). Doesn't scale to well.
The easiest method is to create the moving average measure yourself using DAX. No limitations that way. Quick measure is just a way to generate DAX code through the GUI.
See this guide: https://www.daxpatterns.com/statistical-patterns/#moving-average or https://powerpivotpro.com/2013/07/moving-averages-sums-etc/
Also there is a sloution for your issue.
https://community.powerbi.com/t5/Service/Time-intelligence-does-not-work/td-p/279520
Regards,
Frank
2 Replies
Hi KevinGraham,
The quick measures feature only works on very simple data models ( a single table). Doesn't scale to well.
The easiest method is to create the moving average measure yourself using DAX. No limitations that way. Quick measure is just a way to generate DAX code through the GUI.
See this guide: https://www.daxpatterns.com/statistical-patterns/#moving-average or https://powerpivotpro.com/2013/07/moving-averages-sums-etc/
Also there is a sloution for your issue.
https://community.powerbi.com/t5/Service/Time-intelligence-does-not-work/td-p/279520
Regards,
Frank
Thanks Frank. I managed to write the DAX formula and it works. And those links are most helpful.
