DAX Mastery: CALCULATE, Filter Context, Time Intelligence, Calculation Groups, RLS

DAX Mastery is the fourth volume of the Advanced Excel & Data Modeling series — a complete, production-oriented guide to the language behind Power BI, Power Pivot, and Fabric.

It opens with the two evaluation contexts — row and filter — that explain every DAX result. Then it moves through CALCULATE and its filter modifiers, time intelligence (SAMEPERIODLASTYEAR, DATEADD, YTD/QTD/MTD, rolling window...