Micro Free Course — 100% Free Learning

All lessons in this module are free to learn. Sign in with Google to save your progress.

The DAX Evaluation Engine & Business Logic

Master the internal mechanics of DAX: Filter Context vs Row Context, Context Transition across expanded tables, the 6-step CALCULATE pipeline, and Calculation Groups.

Module Progress0% Complete

280 min total

5 Lessons

0 Completed

Module Content

Evaluation Context in DAX: Filter Context vs Row Context

Visualizing how the DAX Formula Engine parses formulas: coordinate restriction, iterator cursors, and context independence.

16 minVideo

Start

The DAX Engine Deep Dive: CALCULATE, Context Transition & Filter Modifiers

Forensic architecture guide on the 6-step CALCULATE pipeline, expanded table context transition, lazy variable evaluation, and Calculation Groups.

30 minArticle

Start

Time Intelligence: SAMEPERIODLASTYEAR vs DATEADD vs PARALLELPERIOD

Comparative breakdown of DAX time-intelligence functions: exact sub-period grain retention vs full parent interval expansion.

15 minVideo

Start

Quiz: DAX Evaluation Context, Context Transition & Time Intelligence

10 scenario-based psychometric questions testing CALCULATE mechanics, iterator context transition traps, and period shifting.

20 minAssignment

Start

Milestone Project 2: B2B SaaS Financial & Retention DAX Metrics Engine

Build an enterprise calculation layer for a B2B SaaS platform: MRR, ARR, Churn, Net Revenue Retention (NRR), and Calculation Groups.