Calculations (SSAS Tabular)
Applies To: SQL Server 2016
After you have imported data into your model, you can add calculations to aggregate, filter, extend, combine, and secure that data. Tabular models use Data Analysis Expressions (DAX), a formula language for creating custom calculations. In tabular models, the calculations you create by using DAX formulas are used in Calculated Columns, Measures, and Row Filters.
|Understanding DAX in Tabular Models (SSAS Tabular)||Describes the Data Analysis Expressions (DAX) formula language used to create calculations for calculated columns, measures, and row filters in tabular models.|
|DAX Formula Compatibility in DirectQuery Mode (SQL Server Analysis Services)||Describes the differences, lists the functions that are not supported in DirectQuery mode, and lists the functions that are supported but could return different results.|
|Data Analysis Expressions (DAX) Reference||This section provides detailed descriptions of DAX syntax, operators, and functions.|