Rolling Average

[GertjanBoersma]

Hi all, 

I want the average of the last 12 months starting from the last full month and the 12 months back. If a new month is closed the 12 month is changing. month is based on a monthYear notation. Can someone help me. I can't figure it out

[JoeBarry · Accepted solution]

Hi @GertjanBoersma 

I think you will find this article will help you with your needs https://www.sqlbi.com/articles/rolling-12-months-average-in-dax/#:~:text=To%20compute%20the%20rollin....

Thanks

Joe

If this post helps, then please Accept it as the solution