In this video, the instructor introduces the most powerful means of creating measures: building calculated explicit measures using the Power Pivot dialog box. This is where you can use complex combinations of DAX functions to create incredibly powerful an
- Alright, so now let's talk about…the proper way to create explicit measures.…So we're not gonna use the AutoSum shortcut anymore.…Now we're gonna actually write DAX…to create explicit measures through our Power Pivot tab.…So, we'll be in the actual pivot table view…not in our data model…when we create these explicit measures.…So in your Power Pivot tab,…you'll see a button called Measures…and when you click New Measure…it will open up the Measure dialog box…that looks like this.…So at the top of the dialog box you've got…information about the measure.…
Every measure gets assigned to a table…so that you'll know where to find it…in your Pivot Table field list.…Let's give it a measure name…again you can use spaces here if you choose…and you've got an optional description.…So that's kind of up to you…if you want to use descriptions or not.…Generally speaking, I'll add description for the more…complicated measures that might not be so intuitive…but I might just leave it blank…for some of the simpler ones.…So in the case that we're looking at here,…
- 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.