In this video, the instructor introduces the second method of using DAX to create new calculated fields: measures. The instructor explains how they can be used and why they are so powerful, especially when compared to traditional PivotTable calculated fie
- Okay, time for another one of those critical,…top five lectures in the whole course.…We're gonna introduce DAX measures, which is the second…place to use data analysis expressions.…Now, simply put, measures are DAX formulas…that you can use to create dynamic values…within a PivotTable.…Now, like calculated columns, and like any place…you'd use DAX, measures reference entire tables or columns,…so again, no A1-style references, but here's the thing.…
Unlike calculated columns, the measures don't actually…live in the table.…Instead you place them in the values area,…and only the values area, of a PivotTable,…so that they can dynamically calculate…in each individual cell.…This works in a very similar way…to calculated fields in a traditional PivotTable.…Now here's the most important concept,…is that measures are evaluated based on the filter context…of each cell in a Pivot, and that filter context…is determined by the PivotTable layout.…
So, your filters, your slicers, any row labels,…any column labels, all of those elements of your…
- 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.