Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Data Analysis Expressions (DAX) Reference

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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 Designer Preview.

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 Specification for Power Pivot - This topic describes syntax requirements, naming requirements, and different operators and constants used in DAX expressions.

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

Parameter-Naming Conventions (DAX) - This topic describes parameter naming conventions in DAX expressions.

Formula Compatibility in DirectQuery Mode - This topic provides an overview of the differences, lists the functions that are not supported in 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

© 2015 Microsoft