CHAPTER 37Adding Formulas to Power Pivot
When analyzing data with Power Pivot, you'll often find that you need to expand your analysis to include data based on calculations that are not in your original data set. Power Pivot has a robust set of functions called data analysis expressions, or DAX functions, which allow you to perform mathematical operations, recursive calculations, data lookups, and much more.
This chapter introduces you to DAX functions, and it provides the ground rules for building your own calculations in Power Pivot data models.
|
Most of the examples in this chapter are available on this book's website at |
Enhancing Power Pivot Data with Calculated Columns
Calculated columns are columns that you create to enhance a Power Pivot table with your own formulas. Calculated columns are entered directly in the Power Pivot window, becoming part of the source data you use to feed your PivotTable. Calculated columns work at the row level; that is, the formulas that you create in a calculated column perform their operations based on the data in each individual row. For example, imagine you have a Revenue column and ...
Get Excel 2019 Bible now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
