Data Analysis Expressions (DAX) Reference

Data Analysis Expressions (DAX) is a library of functions and operators that can be combined to build formulas and expressions in Power BI Desktop, Azure Analysis Services, SQL Server Analysis Services, and Power Pivot in Excel.


New DAX Functions - This article describes new DAX functions recently added.

DAX Function Reference - articles in this section provide in-depth technical reference information for each of the over 200 different DAX functions. Functions are divided into categories such as Statistical, Filter, Data and Time, etc.

DAX Syntax Reference - This article describes syntax requirements, naming requirements, and different operators and constants used in DAX expressions.

DAX Operator Reference - This article describes the syntax of individual operators used to create expressions that compare values, perform arithmetic calculations, or work with strings.

DAX Parameter-Naming Conventions - This article describes parameter naming conventions in DAX expressions.

DAX Queries - This article describes syntax and parameters for returning table data from a DAX query.