skip to Main Content

Advanced DAX calculation: doing a moving grouped average in PowerPivot

Woops I'm sorry, did I change your Filter Context ?

By Kasper de Jonge, original post at

I got an excellent question last week on the ask my question page that brought me new understanding of DAX. So finally a new interesting (I hope) blog post on DAX.

Let’s say I have a set of sales per week of a specific brand:

Now I want to have the average of sales per week (slicable by brand) and compare it to the average of the last 3 weekly totals. I prepare  the pivottable :

Read the Rest