The DAX language
Browse DAX functions alphabetically from the sidebar or choose a category below:
Aggregation functions return a scalar value applying an aggregation function to a column or to an expression evaluated by iterating a table expression.
Date and Time functions
Date and time functions help creating calculations based on dates and time. Many of the functions in DAX are similar to the Excel date and time functions.
Filter functions manipulate table and filter contexts.
Financial functions corresponding to Excel functions with the same name.
Information functions provide information about data type or filter context of the argument provided.
Logical functions act upon an expression to return information about the values or sets in the expression.
Math and Trig functions
The mathematical functions in DAX are very similar to the Excel mathematical and trigonometric functions.
These are special functions that cannot be classified in other categories.
These functions helps flattening a parent-child relationship in a regular one.
Relationships management functions
These functions manage and manipulate relationships between tables.
Statistical aggregation functions.
Table manipulation functions
These functions manipulate and return tables.
Text functions manipulate strings.
Time Intelligence functions
Time intelligence functions support calculations to compare and aggregate data over time periods, supporting days, months, quarters, and years.
Statements, Operators and Data types
As well as for functions, DAX Guide provides a reference for other entities such as:
Latest DAX functions released:
- 2023-05-03: MATCHBY
- 2023-04-20: EXTERNALMEASURE
- 2023-03-05: ROWNUMBER
About this Reference
The curated content of DAX Guide makes it a go-to reference on the DAX language.
DAX Guide is updated automatically, through the monitoring of new versions of Microsoft products. For every DAX function, DAX Guide offers a compatibility matrix for versions/products supported. Every function/argument is marked with attributes highlighting its behavior regarding row context and context transition.
DAX Guide integrates and expands on the Microsoft documentation.
Last site update: Jun 10, 2023