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.
Related article
Rolling averages over time (a.k.a. moving averages or running averages) are useful to smoothen chart lines and to make trends more evident. This article shows how to compute a rolling average over 12 months, in DAX.
Read related article