Where to create PowerPivot calculations and why
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: