In this video, the instructor introduces the first method of using DAX to create new calculated fields: calculated columns. The instructor showcases some "good" and "bad" examples, and demonstrates how they can be created within the data model window.
- [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 means they're great for defining things…
- Power Pivots versus normal pivots
- Creating calculated columns and measures
- Power Pivot and DAX best practices
- Math, stats, and COUNT functions
- CALCULATE, FILTER, and ALL functions
- Joining data with RELATED
- Using iterator functions (SUMX and RANKX)
- Time intelligence formulas
Skill Level Intermediate
1. Getting Started
Set expectations1m 46s
2. Power Pivot and DAX 101
3. Common DAX Functions
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.