In this video, the instructor recap the similarities and differences between calculated columns and DAX measures, and explain when to use one approach vs the other.
- All right, so at this point,…we've talked about how DAX can be used…in two different places,…calculated columns and measures, both implicit and explicit.…At the point, I want to take a big step back…and compare the two.…The reason it's worth focusing on this…is that you'll find many situations…where you could use either option.…So it's important to understand…the similarities and differences…so that you know what your best choice might be.…Now, starting with calculated columns,…these are evaluated in the context of each row of the table…to which they belong.…
In other words, they have row context.…Second, they actually append static values, or attributes,…to each row in the table and stores them with the model.…So that increases the file size.…Third, they're only recalculated on data source refresh…or when you make changes to component columns,…meaning columns that are actually included…in the calculation that you're making.…And then finally, these are primarily used as rows,…columns, slicers or filters in your pivot table.…
- 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.