Home > Sample chapters > Programming > SQL Server

Microsoft SQL Server 2012 Analysis Services: DAX Basics

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.