From the course: Excel Business Intelligence: Power Pivot and DAX

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Recap: Calculated columns versus measures

Recap: Calculated columns versus measures - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Power Pivot and DAX

Start my 1-month free trial Buy for my team

Recap: Calculated columns versus measures

“

- All right, so at this point, we've talked about how DAX can be used in two different places, calculated columns and measures, both implicit and explicit. At the point, I want to take a big step back and compare the two. The reason it's worth focusing on this is that you'll find many situations where you could use either option. So it's important to understand the similarities and differences so that you know what your best choice might be. Now, starting with calculated columns, these are evaluated in the context of each row of the table to which they belong. In other words, they have row context. Second, they actually append static values, or attributes, to each row in the table and stores them with the model. So that increases the file size. Third, they're only recalculated on data source refresh or when you make changes to component columns, meaning columns that are actually included in the calculation that you're making. And then finally, these are primarily used as rows…

Contents