Unit IV — DAX & Advanced Modeling

Unit IV · DAX & Advanced Modeling (≈12 hours)

1. DAX Essentials

Calculated columns vs measures; filter context vs row context.
Common functions: SUMX, CALCULATE, FILTER, ALL, RELATED, DATESYTD.

2. Relationships & Filtering

Managing relationships, cross-filter direction, many-to-many patterns.
Role-playing date tables; user roles and RLS (overview).

3. KPI Examples

-- Measures
Total Sales := SUM(FactSales[SalesAmount])
LY Sales := CALCULATE([Total Sales], DATEADD('DimDate'[Date], -1, YEAR))
YoY % := DIVIDE([Total Sales] - [LY Sales], [LY Sales])
CLV := SUMX(Customers, Customers[AvgOrderValue] * Customers[RepeatRate])

E‑commerce case: CLV, repeat rate, cohort retention, margin analysis, and custom KPI cards.