Calculated Columns
Calculated Tables
Measures
These are added to the tables by applying the DAX formula to the existing data.
It defines values in the new column rather than putting queries on data resources.
It is used when data sources do not contain data presented in a specific format.
These are created by using the DAX formula to define values.
Created in both Data Views and reports.
Works for the intermediate calculations, and the data that the user wants to be stored in the model.
It uses other DAX functions to make complex calculations.
Used for highlighting the running totals and for comparing sales forecasting, and more.
Used for creating both Report and Data Views.
