Excel Power Pivot and Power Query For Dummies

Chapter 6

Adding Formulas to Power Pivot

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.

Enhancing Power Pivot Data with Calculated Columns

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 ...