Data Analysis Expressions (DAX) Reference

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 Microsoft SQL Server Analysis Services, Power Pivot in Excel, and Power BI Desktop.

In This Section

DAX Function Reference - Topics 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 topic describes syntax requirements, naming requirements, and different operators and constants used in DAX expressions.

DAX Operator Reference - This topic 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 topic describes parameter naming conventions in DAX expressions.

DAX Formula Compatibility in DirectQuery Mode (SQL Server Analysis Services) - This topic provides an overview of the differences, lists the functions that are not supported in SQL Server Analysis Services DirectQuery mode, and lists the functions that are supported but might return different results.

DAX Queries - SQL Server 2012 This section describes syntax and parameters for returning table data from a DAX query.

DAX Error Reference – This section included topics for some of the most common errors returned from DAX.

Community Additions

© 2016 Microsoft