| Where to create PowerPivot calculations and why |
| Written by Kasper de Jonge |
| Tuesday, 01 June 2010 00:28 |
|
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:
|
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?
