Where to create PowerPivot calculations and why

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

Yesterday i had a excellent question and mail conversation with Jan at my ask a question page concerning strange  measure behaviors. It appeared he had used a calculated column where he had to use a calculated measure to get the result he wanted. In this blog post i try to explain where you should create your measure and why you should use one or the other.

In PowerPivot we have two ways to create new information using DAX formula’s. Using the definition from the MS PowerPivot blog post about measures:

Read more...

 

Tags: dax, excel

 

2007-2015 VidasSoft Systems Inc.