Computing rolling average in DAX

Computing the rolling 12-months average in DAX looks simple, but it hides some level of complexity. This article explains how to write the best formula and how to avoid common pitfalls using time intelligence functions.

[mathew]

I wish I could understand DAX in such a fluent manner, to be able to quickly throw that type of measure/calculated group together. Pure Joy & art to see someone who is fluent create such a powerful visual

[mangeshmehendale]

Alberto and Marco - your videos fill me with pure unadulterated joy!

[anson]

I like the way he explains. It is clear and soothing.

[kaito]

Sir, I would like to thank you so utterly from the bottom of my heart. I've been unable to use 12M rolling avg in my powerbi as something funky always happened in the background that left me with wonky values.. I've been searching for days, have watched countless videos and help threads and nothing worked. That is, until I came across your fabulous video. It finally worked! Thank you so much!

[tiffanyharris]

I wish Youtube had a LOVE button! THANK YOU FOR

[vijayvizzu]

Nobody teaches like you.. you explained the logic, thereafter you applied in the blank model. Even we can't expect this much of explanation in paid courses. Thank for you sharing your knowledge :)

[roadtech]

Amazing! You handle DAX like Einstein used to handle phisics.
Congrats Alberto! Thanks for sharing knowledge.

[motichoorladdu]

This has been the latest requirement in my organization and I am just getting to creating this calculation group. You just brought sped up my implementation time. Super greatful!!

[michaelazelena]

This is finally a working manual for rolling average. Perfect job!

[ashishmohan]

Hi Alberto,

You are really amazing & Rockstar in DAX
after watch your Power BI tutorial I realize DAX is very easy.
your way of explanation is very very simple and clear .
Thanks you have been created these very important tutorial all of us.
Thanks

[raqzg]

Excellent - love how you made the concept easy to understand. What I really like is you explained it with a big picture in mind, and very logical. Thank you for sharing.

[Truth-N-Lies]

Matero, Salute to you for your art of teaching DAX

[lbarbyery]

This is a good case of use and a practical way to use all the flexibility of calc groups of DAX. Thanks to share with us!

[cesarebellentani]

You are always the number one! I find always a solution to my Power BI problems in your videos! and very clear. Thank you

[alexandreluizrosa]

Thank you so much! I could finish a presentation at work because of your help and expertise. Thank you!

[mounjayansaha]

Thank you so much. This is the best video I have seen on Running averages.

[alohaaloha]

This is so helpful! Alberto always has the best in-depth analyses. Just an interesting observation: the FirstSelectedDay <= LastSelectedDate can only solve the blank values in prior periods; it doesn't solve the blank values in future periods. For example, rolling 3-month will show values for the future two months.

[andreeaolah]

Real mastery indeed. Wow!! Love the elegant solution!! Thank you for the awesome () !!

[panyaphatthurapra]

Always the best tutorial I could ask to solve my problem. Thank you 🙏🏻

[sbn]

every video takes big pleasure.After reading your book Thanks you 👍👍👍👍👍👍