Forum Discussion

New Member

5 years ago

12 Month Rolling Average - Sample Data Included

I need to get a 12 month rolling average to work but I get the "Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column." error...

Anonymous

Not applicable

5 years ago

Hi mwall ,

Hope this help:

https://community.powerbi.com/t5/Desktop/How-to-create-rolling-averages-over-non-consecutive-dates/m-p/1410175

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Time-Intelligence-Quick-Measures-Problem/m-p/1206899

Or you could go to https://community.powerbi.com/t5/forums/searchpage/tab/message?filter=solvedThreads&q=rolling%20average%20Time%20intelligence%20quick%20measures%20can%20only%20be%20grouped&noSynonym=false&solved=true&sort_by=-topicPostDate&collapse_discussion=true for reference.

Best Regards,
Eyelyn Qin