Internship
Student login
← Power BI & Excel learning path
Power BI & Excel · Module 7 of 10

DAX fundamentals

Create measures and calculations with DAX.

📖 Key ideas

  1. DAX is Power BI's formula language.
  2. Measures calculate on the fly: Total Sales = SUM(Sales[Amount]).
  3. Calculated columns compute per row and are stored.
  4. CALCULATE changes filter context: Sales South = CALCULATE([Total Sales], Region[Name] = "South").
  5. Time intelligence: TOTALYTD, SAMEPERIODLASTYEAR, DATEADD.
💡 Real-life example: DAX measures are smart calculators that re-compute for whatever slice of data you look at.
DAXData Analysis Expressions
MeasureDynamic calculation
CALCULATEEvaluates with modified filters
Filter contextFilters applied to a calculation