Forum Discussion
Help needed: Having trouble calculating the rolling average
Hi I've grouped my dates and created a separate table to show the values I need per day however, my rolling average is in the original format my dates were in prior to grouping so I am not gettin...
HotChilli
Community Champion
Community ChampionIt's not the Date that you want in the sum. It will be a numeric field required.
There's other problems too (I don't think this is a rolling average and you should use a dates table if you are using DATESINPERIOD)
Try this to help :
https://www.sqlbi.com/articles/rolling-12-months-average-in-dax/