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.
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. I have tried many suggestions on this forum but nothing has worked for me yet.
I need to get a rolling average of the count of events, either by using the Car Number field or the unique Service Event ID field.
The data look like this but with many more rows:
Car Number | Repair Completed Date | Service Event Id |
Car2835 | 10/09/2019 | 3277179 |
Car2544 | 11/13/2019 | 3304354 |
Car4047 | 05/08/2019 | 3168519 |
Car4042 | 05/09/2019 | 3168520 |
Car2159 | 01/09/2020 | 3360913 |
Car538 | 08/07/2020 | 3490242 |
Car1393 | 04/06/2020 | 3437747 |
Car2633 | 11/01/2019 | 3250245 |
Car3864 | 05/30/2019 | 3090304 |
Car1783 | 02/21/2020 | 3361017 |
Car387 | 09/03/2020 | 3547835 |
Car392 | 09/03/2020 | 3547834 |
Car718 | 07/10/2020 | 3491320 |
Car2973 | 09/23/2019 | 3166268 |
Car804 | 06/26/2020 | 3519201 |
Car3982 | 05/16/2019 | 3116654 |
Car263 | 09/25/2020 | 3547041 |
Car4482 | 03/13/2019 | 3018029 |
Car4617 | 02/21/2019 | 3043578 |
Car3154 | 08/28/2019 | 3191166 |
Car2007 | 01/28/2020 | 3408982 |
Car3650 | 06/24/2019 | 3067963 |
Car585 | 07/31/2020 | 3464028 |
Car1380 | 04/08/2020 | 3461921 |
Car4931 | 01/02/2019 | 3015548 |
Car862 | 06/18/2020 | 3462104 |
Car1771 | 02/24/2020 | 3329807 |
Car632 | 07/23/2020 | 3328718 |
Car834 | 06/24/2020 | 3463181 |
Car3388 | 07/29/2019 | 3143151 |
Car803 | 06/26/2020 | 3466278 |
Car122 | 10/21/2020 | 3546984 |
Car1981 | 01/31/2020 | 3384241 |
Car58 | 11/02/2020 | 3493281 |
Car3040 | 09/13/2019 | 3220240 |
Car314 | 09/18/2020 | 3575954 |
Car941 | 06/05/2020 | 3461906 |
Car758 | 07/02/2020 | 3517379 |
Car1186 | 05/01/2020 | 3384757 |
Car814 | 06/25/2020 | 3462948 |
Hi @mwall ,
Hope this help:
Or you could go to https://community.powerbi.com/t5/forums/searchpage/tab/message?filter=solvedThreads&q=rolling%20aver... for reference.
Best Regards,
Eyelyn Qin
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.