Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have created a rolling average quick measure.
Im getting this message and really dont understand what needs to be done to rectify it -
"Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."
I have a date table that I generate in SQL but this is not marked as a Date Table. For time intelligence features in PBI do I need a table marked as a Date Table ?
Grateful for any assistance.
Griggers
Hi, @Griggers
I found the explaination in docement.
Here are the points to note:
Reference: Use quick measures for common and powerful calculations - Power BI | Microsoft Docs
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Janey,
I have tried what has been suggested abaive, and still getthe same error.
All my datasets are import mode. Any suggestions ?
Thanks
Mark
Hi, @Griggers
Can you share some fake sample data and more information about how you do it? Otherwise, it’s hard to judge the specific reason.
Best Regards
Janey Guo
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.