In this video, the instructor demonstrates how to use the data model's AutoSum feature to quickly create basic measures using common functions (SUM, COUNT, AVERAGE, and so on).
- [Instructor] Shifting gears into explicit measures.…There are a couple of ways to create explicit measures.…There is the lazy way and there's the proper way.…So right now, I'm gonna show you very quickly the lazy way,…and then we won't use this approach ever again…through the rest of the course.…But I feel obligated to show you…just so that you know it exist.…Now, consider this Data View from the data model.…Note this pane at the bottom,…which you may have seen earlier in the course…and been a little confused by, which I don't blame you.…
It's kind of a strange layout,…but they call that the Measures Pane…or the Calculation Area,…which you can actually turn it on and off…right here in this button that says Calculation Area…in the Home tab.…And as we start creating measures,…they'll start populating down here in the Measures Pane.…You could see down here…there's actually a Revenue Measure that had been created…for this screenshot, and it just sits down here…and it tells you, hey, there's a measure that exists…
- 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.