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!

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.

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!