The 8 Pillars of DAX

Select a category title to view details, or jump directly to a formula.

01. Aggregation ➜

Math basics, handling blanks vs zeros, and counting logic.

SUM vs SUMX ⚪ AVERAGE / AVERAGEA ⚪ MIN / MAX ⚪ COUNT / COUNTROWS ⚪ DISTINCTCOUNT ⚪

02. Filter Context ➜

Modifying context, removing slicers, and handling relationships.

CALCULATE ⚪ FILTER ⚪ ALL / ALLEXCEPT ⚪ VALUES vs DISTINCT ⚪ RELATED ⚪

03. Time Intelligence ➜

YTD calculations, Year-over-Year comparisons, and moving averages.

TOTALYTD ⚪ SAMEPERIODLASTYEAR ⚪ DATEADD ⚪ DATESINPERIOD ⚪ PARALLELPERIOD ⚪ CALENDAR / AUTO ⚪

04. Logical ➜

Conditional logic, branching paths, and error handling.

IF / Nested IF ⚪ SWITCH ⚪ AND / OR / NOT ⚪ IFERROR ⚪

05. Information ➜

Checking state: Is it blank? Is it filtered? Detecting totals.

ISBLANK ⚪ HASONEVALUE ⚪ ISFILTERED ⚪ ISCROSSFILTERED ⚪ USERELATIONSHIP ⚪

06. Text Functions ➜

String manipulation, extraction, searching, and formatting.

CONCATENATE & X ⚪ LEFT / RIGHT / MID ⚪ LEN ⚪ UPPER / LOWER ⚪ SEARCH ⚪

07. Math & Stats ➜

Safe division, rounding precision, and statistical ranking.

DIVIDE ⚪ ABS ⚪ ROUND ⚪ RANKX ⚪

08. Table Manipulation ➜

Creating virtual tables, grouping, joining, and appending data.

SUMMARIZE ⚪ ADDCOLUMNS ⚪ CROSSJOIN ⚪ UNION ⚪

🚀

Advanced Patterns

Future modules planned for the DAX Masterclass.

Parent-Child Hierarchy 🚧 Advanced Time Intel 🚧 Iterator Optimization 🚧 SVG in DAX 🚧