CHAPTER 37
Adding 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...
