Introduction to DAX

Topics Covered

• DAX fundamentals
• Calculated columns
• Measures
• Evaluation context
• Row context
• Filter context
• Basic aggregation functions
• Date functions
• Text functions
• Logical functions

Module Description

• Learners begin working with DAX, the analytical language used in Power Pivot. They create calculated columns and measures that extend reporting capabilities beyond traditional Excel formulas.

Hands-on Lab

• Build custom business calculations using DAX
• Compare calculated columns and measures