In This Chapter
Creating, formatting, and hiding your own calculated columns
Creating calculated columns by using DAX
Creating calculated measures
Breaking out of pivot tables with cube functions
When analyzing data with Power Pivot, you often find the need to expand your analysis to include data based on calculations that are not in the original dataset. Power Pivot has a robust set of functions (called DAX functions) that allow you to perform mathematical operations, recursive calculations, data lookups, and much more.
This chapter introduces you to DAX functions and provides the ground rules for building your own calculations in Power Pivot data models.
Calculated columns are columns you create to enhance a Power Pivot table with your own formulas. When you enter calculated columns directly in the Power Pivot window, they become part of the source data you use to feed your pivot table. Calculated columns work at the row level. That is to say, the formulas you create in a calculated ...