DAX is what turns a Power BI report into real analysis. These functions cover most everyday needs.
CALCULATE
The most important function in DAX. It changes the filter context: Sales West = CALCULATE([Total Sales], Region[Name] = "West").
SUMX and other iterators
Iterators evaluate an expression row by row: Revenue = SUMX(Sales, Sales[Qty] * Sales[Price]).
Time intelligence
TOTALYTDfor year-to-date totalsSAMEPERIODLASTYEARfor year-over-year comparisonsDATEADDfor flexible period shifts
DIVIDE
Use DIVIDE([Profit], [Sales]) instead of the / operator to handle divide-by-zero safely.