| Advanced DAX calculation: doing a moving grouped average in PowerPivot |
| Written by Kasper de Jonge |
| Tuesday, 22 March 2011 00:46 |
|
I got an excellent question last week on the ask my answers 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 :
|
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?
