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

Calculations (SSAS Tabular)

 

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.

In This Section

Topic

Description

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.

 

System_CAPS_noteNote

Step-by-step tasks for creating calculations are not provided in this section. Because calculations are specified in calculated columns, measures, and row filters (in roles), instructions on where to create DAX formulas are provided in tasks related to those features. For more information, see Create a Calculated Column (SSAS Tabular), Create and Manage Measures (SSAS Tabular), and Create and Manage Roles (SSAS Tabular).

System_CAPS_noteNote

While DAX can also be used to query a tabular model, topics in this section focus specifically on using DAX formulas to create calculations.

Community Additions

ADD
Show:
© 2015 Microsoft