Quick Measure Error: "Only Power BI-provided date hierarchies are supported"

Question

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.

Solution

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/