Calculated versus computed columns
In the previous chapter you learned how to create a new, composite key, for the Geography dimension by merging three columns together in Power Query. Now, we'll also create the composite key through DAX.
You'll use two different tables in this exercise. In one you'll compute a custom column in Power Query, and in the other table you'll use DAX to create a calculated column. Let's compare which method leads to a better performance, computed columns created in Power Query or calculated columns created in DAX.
This exercise is part of the course
Intermediate Data Modeling in Power BI
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
