Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Calculating rolling average based on a expression and connection with a second data table

Hi all,   My data is as follows: I have 2 Date Tables, one is called 'D Kalender'  and the other is called 'D Kalender Previous'. The 'D Kalender Previous' is table which is a copy of 'D Kalender'...
some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous I would suggest, if you are not already, saw link related to this topic, rolling average as I do not understand your measure (I tried to figure out but no luck :))

One tip based on experience: only have one Date table, otherwise complexity is created sooner or later.

Hope this help.

https://www.sqlbi.com/articles/rolling-12-months-average-in-dax/