From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Unlock this course with a free trial

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

Calculated columns

Calculated columns - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Start my 1-month free trial Buy for my team

Calculated columns

“

- [Instructor] All right, let's dive into calculated columns, the first place to use DAX expressions. Now, as you might have guessed, calculated columns, super simple. They allow you to add new formula-based columns to a table. Very similar to how we added new columns in Power Query using the query editor. Very similar concept here. Now, a couple things to note. There's no A-1-style references here. Calculated columns refer to entire tables or columns. Also, calculated columns are computed row by row, and those values that you compute get stored with the table, which does take up memory. So this is fine if you're dealing with reasonably sized datasets. But if you're working with very large datasets, keep in mind that adding more and more calculated columns will slow things down and eat up that memory. And then third, this is probably the most important bullet of the three, is that calculated columns are designed to…

Contents