Quick Measure - Time Intelligence - my own date table

[KevinGraham]

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

[v-frfei-msft · Accepted solution]

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

[KevinGraham]

Thanks Frank.  I managed to write the DAX formula and it works.  And those links are most helpful.