I am attempting to create a rolling average quick measure using time intelligence. When I drop my DATE variable into the Date field I get the error message "Only Power BI-provided date hierarchies are supported".
How do I fix this? I've tried to use the solution posted here but it is not working for me. My date column is also formatted as date/time. I appreciate any help.
I was able to resolve this issue.
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/