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 everyone,
Im trying to make a rolling x-month average for a satisfaction score, but it only works if i use 7months or more. with 6 or less there is no error shown, but the field just stays empty. Anyone an idea how to solve this?
Solved! Go to Solution.
Hi @Anonymous ,
While using a time intelligence function,you'd better first create a date table,then check the vedio below:
https://www.youtube.com/watch?v=HJ95vtzsuIY
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
@Anonymous , what is the measure you tried?
Try a measure like the example
Rolling 6 = CALCULATE(Average(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-6,MONTH))
Rolling 6 = CALCULATE(AverageX(values('Date'[Month year]),Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-6,MONTH))
I have tried a quick measure time intelligence - rolling average. It does come up with an error around the date hierarchy that I have created; grouping or filtering is only possible on a date hierarchy supplied by powerBI or a primary date column.
Hi @Anonymous ,
While using a time intelligence function,you'd better first create a date table,then check the vedio below:
https://www.youtube.com/watch?v=HJ95vtzsuIY
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
sorry half of it is in Dutch...
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.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |