In this video, the instructor introduces the SWITCH function in DAX, and demonstrates how it can be combined with TRUE to eliminate the need for nested IF statements to test multiple criteria.
- [Instructor] Alright, next up we've got two functions…that you probably haven't seen before.…Switch and a variation of switch called switch true.…Now, the official definition…of the switch function sounds like this.…It evaluates an expression against a list of values…and returns one of multiple possible result expressions.…Now, I don't understand that either.…That's straight from Microsoft.…I think they make it sound…much more complicated than it really is.…And the thing is when we look…at the formal syntax of the function,…it's still a little bit confusing.…
So, it starts with an expression,…and that expression can be any DAX expression that returns…a single scalar value, evaluated multiple times.…So, still kind of overly complicated here.…And in the context that we're gonna use switch,…in the context that most people use switch,…that expression can simply be a column name.…So, like Calendar_Lookup[month_num]…or Product_Lookup[product_brand].…And then from there you've got…these pairs of values and results.…
- 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.