SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

PowerPivot default measure aggregation

One of the PowerPivot advantages is flexibility of changing measure aggregation for instance changing average to minimum. PowerPivot applies default aggregation to a measure and usually it is SUM but in our case SUM does not make any sense so in this tutorial I will show how to change default aggregation to an average and still have flexibility of changing in PivotTable to for instance minimum.

Katie and Emil

We are Katie & Emil and together we have decided to learn more & more on how to build data warehouses using Microsoft products. The best option to learn is to teach so we write tutorials and share it with others.

Comments

Leave a comment on the original post [www.katieandemil.com, opens in a new window]

Loading comments...