DAX (Data Analysis Expressions) Measures in PowerPivot
Introduction to DAX Measures
It’s been a while since I talked about the DAX formula language in PowerPivot, and wanted to take this opportunity to present some examples showing how DAX formulas can be used to define measures in PowerPivot.
Before we get to the new functions and examples, let me review some basic points about the DAX expression language:
DAX formulas can be used to define calculated columns in a table and they can also be used to define measures. Calculated columns are just like in Excel – you enter a formula, and that formula is evaluated for each row in the table, effectively filling in the entire column with values.