| Calculated Columns | Calculated Tables | Measures |
| Added to tables by applying DAX formula on the existing data | Created using DAX formula to define values | Use other DAX functions to create complex calculations |
| DAX formula defines values in new columns rather than querying data sources | Created in both Report and Data views | Used for highlighting running totals, comparing sales, sales forecasting, and other purposes |
| Useful when data sources do not contain data presented in the desired format | Work well for intermediate calculations and the data that users want to be stored in the model | Created in both Report and Data views |
