From the course: Power BI Data Analyst Associate (PL-300) Cert Prep: Create Model Calculations Using DAX

Unlock the full course today

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

Calculated columns vs. measures

Calculated columns vs. measures - Power BI Tutorial

From the course: Power BI Data Analyst Associate (PL-300) Cert Prep: Create Model Calculations Using DAX

Start my 1-month free trial Buy for my team

Calculated columns vs. measures

“

- [Instructor] As we follow data transformation best practices, we usually will remove any fields that can be derived from a calculated value. An example of this would be sales total, inclusive of sales tax, a profit field, when we have the cost and sales field, and other examples similar to those. One of the reasons for removing unnecessary fields is that we want to keep the data set as small as possible as this conforms with best practices for good model design. Though it is best practice, there are times when we will need to add fields to our tables for different reasons. There are two options for this. Calculated columns and measures. Let's look at some of the differences and similarities between the two. Calculated columns are useful for different types of data, whether text or numeric values. They're created using DAX and will become a new field which will automatically take the data type of the fields used to…

Contents