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.
Calculated columns - Microsoft Excel Tutorial
From the course: Excel Business Intelligence: Power Pivot and DAX
Calculated columns
- [Narrator] Alright, 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 A1-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 data sets. But if you're working with very large data sets, 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 understand row context. So they understand the row in which they live. That…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
(Locked)
Introduction to Power Pivot and DAX29s
-
Create a Power Pivot table5m 27s
-
(Locked)
Power Pivots versus normal pivots2m 48s
-
(Locked)
Introduction to Data Analysis Expressions (DAX)1m 12s
-
(Locked)
Calculated columns8m 39s
-
(Locked)
DAX measures2m 24s
-
(Locked)
Create implicit measures1m 59s
-
(Locked)
Create explicit measures (AutoSum)7m 8s
-
(Locked)
Create explicit measures (Power Pivot)7m 42s
-
(Locked)
Understand filter context9m 18s
-
(Locked)
Step-by-step measure calculation12m 6s
-
(Locked)
Recap: Calculated columns versus measures2m 29s
-
(Locked)
Power Pivot best practices1m 48s
-
(Locked)
-
-