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 notation. Can someone help me. I can't figure it out
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
1 Reply
- JoeBarry
Solution Sage
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