Microsoft SQL Server 2012 Analysis Services: DAX Basics
- 7/15/2012
- Understanding Calculation in DAX
- Understanding Calculated Columns and Measures
- Calculated Columns
- Measures
- Handling Errors in DAX Expressions
- Common DAX Functions
- Using Basic DAX Functions
- Summary
Understanding Calculated Columns and Measures
Now that you know the basics of DAX syntax, you must learn one of the most important concepts in DAX: the difference between calculated columns and measures. Even though they might appear similar at first sight because you can make some calculations both ways, you must use measures to implement the most flexible calculations. This is a key to unlock the true power of DAX.