Calculating moving averages in DAX

Written by Javier Guillen on 05 July 2011.

A common calculation required in business is moving averages. How can we create it in DAX? Lets walk through the calculation.

Imagine we have the following PowerPivot table: