Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

undefined

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 emp...

Need Help

v-kelly-msft
5 years ago
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!

amitchandak

Super User

5 years ago

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))

Anonymous

Not applicable

5 years ago

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.

Anonymous
Not applicable
5 years ago
sorry half of it is in Dutch...
v-kelly-msft
Community Support
5 years ago
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!