Introduction to DAX

Power Pivot in Excel

Nick Edwards

Analyst at Roofstock

Data Analysis Expressions

• DAX: Data Analysis eXpressions
• Used in Microsoft applications
• Create calculations and measures
• 200+ functions in DAX
  • https://learn.microsoft.com/en-us/dax/

¹ https://learn.microsoft.com/en-us/dax/dax-overview

Syntax of DAX

Syntax of DAX

Syntax of DAX

Syntax of DAX

Syntax of DAX

Syntax of DAX

Calculated columns vs measures

Columns

Measures

• Evaluated at the row level
• Adds a new column to an existing table
• Calculated at data load

• Aggregates many rows
• Adds a field, not a column, that can be visualized
• Calculated at query time

Row context

Row context

Row context

Filter context

Let's practice!

Power Pivot in Excel