13  Using Data Analysis Expressions (DAX) in Power BI


Summary

Concept Description
Foundations
DAX Syntax Function-based language for analytical expressions in models
Calculated Columns New columns evaluated row-by-row at refresh time
Measures Aggregations evaluated in the filter context of the visual
Advanced DAX
CALCULATE The keystone function that modifies filter context for measures
Filter Context The set of filters applied when a DAX expression is evaluated
Time Intelligence DATEADD, SAMEPERIODLASTYEAR, and similar date-based functions
Iterators SUMX, AVERAGEX, and other functions that loop over a table
Variables VAR / RETURN to clarify intent and avoid recomputation