DAX Cheat Sheet | Notion

Category	Description	Key Functions
📊 Math & Statistical Functions	Perform basic calculations and statistical analysis	`SUM`,`AVERAGE`,`COUNT`,`SUMX`,`AVERAGEX`,`RANKX`,`MEDIAN`,`GEOMEAN`,`DISTINCTCOUNT`
🔍 Filter & Context Functions	Modify filter context for calculations	`CALCULATE`,`FILTER`,`ALL`,`ALLEXCEPT`,`REMOVEFILTERS`,`HASONEVALUE`
✅ Logical Functions	Build logical expressions and handle errors	`IF`,`AND`,`OR`,`NOT`,`SWITCH`,`IFERROR`
🕒 Date & Time Functions	Work with dates and times	`DATE`,`DAY`,`MONTH`,`YEAR`,`DATEDIFF`,`CALENDAR`
⏳ Time Intelligence Functions	Analyze data across time periods	`SAMEPERIODLASTYEAR`,`TOTALYTD`,`DATEADD`,`DATESBETWEEN`
🔗 Relationship Functions	Work with table relationships	`RELATED`,`CROSSFILTER`
📋 Table Manipulation Functions	Shape and transform tables	`SUMMARIZE`,`GROUPBY`,`ADDCOLUMNS`,`SELECTCOLUMNS`,`UNION`,`INTERSECT`
✏️ Text Functions	Manipulate string values	`LEFT`,`RIGHT`,`UPPER`,`LOWER`,`SUBSTITUTE`,`CONCATENATE`
ℹ️ Information Functions	Test values and retrieve metadata	`ISBLANK`,`ISNUMBER`,`ISFILTERED`,`USERPRINCIPALNAME`,`NAMEOF`
🧠 DAX Statements & Operators	Core syntax elements	`VAR`,`COLUMN`,`ORDER BY`,`=`,`>`,`<`,`&&`,`

📊 Math & Statistical Functions

Perform basic calculations like SUM, AVERAGE, COUNT, and their iterator versions like SUMX, AVERAGEX, etc.
Also includes ranking (RANKX) and distribution tools like MEDIAN, GEOMEAN, and DISTINCTCOUNT.

🔍 Filter & Context Functions

Core tools for modifying filter context: CALCULATE, FILTER, ALL, ALLEXCEPT, REMOVEFILTERS.
Use HASONEVALUE to check filter granularity.

✅ Logical Functions

Classic logic building blocks: IF, AND, OR, NOT, SWITCH, and error handling with IFERROR.

🕒 Date & Time Functions

Extract or compute parts of dates: DATE, DAY, MONTH, YEAR, etc.
Compute intervals with DATEDIFF and generate calendars with CALENDAR.

⏳ Time Intelligence Functions

Analyze time-based data: SAMEPERIODLASTYEAR, TOTALYTD, DATEADD, DATESBETWEEN, etc.

🔗 Relationship Functions

Manage relationships: RELATED pulls in values from related tables, CROSSFILTER defines relationship behavior in calculations.

📋 Table Manipulation Functions

Shape tables with SUMMARIZE, GROUPBY, ADDCOLUMNS, SELECTCOLUMNS, UNION, INTERSECT.

✏️ Text Functions