The DAX language
Functions
Browse DAX functions alphabetically from the sidebar or choose a category below:
-
Aggregation functions
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
Filter functions manipulate table and filter contexts.
-
Financial functions
Financial functions corresponding to Excel functions with the same name.
-
Information functions
Information functions provide information about data type or filter context of the argument provided.
-
Logical functions
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.
-
Other functions
These are special functions that cannot be classified in other categories.
-
Parent-child functions
These functions helps flattening a parent-child relationship in a regular one.
-
Relationships management functions
These functions manage and manipulate relationships between tables.
-
Statistical functions
Statistical aggregation functions.
-
Table manipulation functions
These functions manipulate and return tables.
-
Text functions
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:
Updates
Latest DAX functions released:
- 2024-09-19: INFO.VIEW.TABLES
- 2024-09-19: INFO.VIEW.RELATIONSHIPS
- 2024-09-19: INFO.VIEW.MEASURES
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: Dec 12, 2024