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.