In this video, the instructor introduces arguably the most powerful DAX function of all: CALCULATE. The instructor explains exactly how this function can be used, and demonstrates several examples applied to your course project files.
- [Instructor] So up until this point,…you might be asking yourself,…what's so special about this DAX language anyway?…Based on what we've looked at so far,…these logical operators, these calculated columns,…these text formulas, it's all extremely similar…to regular old Excel syntax.…In fact, in many cases, it's just about identical…with the exception that we're pointing to…columns and tables instead of individual cells.…We've had a few interesting nuggets…like distinct count is pretty cool,…and switch is a great option.…
But we haven't really begun to scratch the surface…of what DAX is really capable of.…And that's gonna change now.…Because now we're shifting gears into…the DAX filter functions.…And these functions are really what starts…to set DAX apart as a distinct formula language.…And we're gonna kick it off with hands-down,…the most popular filter function of all, called calculate.…So, calculate basically just evaluates…an expression or a formula under a set…of defined filters.…
Syntax is pretty simple.…You start with an expression.…
- 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.