Forum Discussion
Rolling Average
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 notati...
Hi Anonymous
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%20rolling%20average,implemented%20in%20a%20regular%20measure.
Thanks
Joe
If this post helps, then please Accept it as the solution
JoeBarry
Solution Sage
Solution SageHi Anonymous
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%20rolling%20average,implemented%20in%20a%20regular%20measure.
Thanks
Joe
If this post helps, then please Accept it as the solution