Learn how to use the function SWITCH in DAX/ Powerpivot.
Switch is the equivalent of IF but it has easier syntax and therefore it is easier to read.
PREVIOUS VIDEO: youtube.com/watch?v=-Ola264bKXk
NEXT VIDEO: -
Looking for the download file? Go to our Download Center: curbal.com/donwload-center and then click on Dax fridays.
Keynotes:
01:45 Create an IF statement
02:37 Create a simple SWITCH calculated column
05:01 Create a SWITCH function with TRUE
08:22 Example of a wrong SWITCH function with TRUE
10:22 Create a SWITH function that returns blanks on blank rows
11:46 Create a measure with SWITCH and FORMAT
Looking for a download file? Go to our Download Center: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
ABOUT CURBAL:
Website: curbal.com
Contact us: curbal.com/contact
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: goo.gl/rvIBDP
► Facebook: goo.gl/bME2sB
#daxfridays #curbal #SUBSCRIBE
► Linkedin: goo.gl/3VW6Ky
- DAX Fridays! #15: SWITCH ( Download)
- D5 Products between 15 and 25 dollars | 25 Days of DAX Fridays! Challenge ( Download)
- DAX Fridays! #207: IF.EAGER | What are eager evaluations ( Download)
- Logical function - Switch (DAX)| Logical function (DAX) In Power BI - Day 15- #gokultech ( Download)
- DAX Fridays! #124: Weekly time intelligence in Power BI ( Download)
- SWITCH - DAX Guide ( Download)
- QT#20 - Why switch to SWITCH() - use SWITCH() DAX function in Power BI as an alternative to IF() ( Download)
- D4 Products above average price | 25 Days of DAX Fridays! Challenge ( Download)
- Power BI: Use DAX Switch Function to Make IF Functions Easier ( Download)
- DAX Fridays #183: Use blank() as date in some DAX functions ( Download)
- DAX Fridays! #8: CALCULATE (Part 2) ( Download)
- D2 Most expensive product | 25 Days of DAX Fridays! Challenge ( Download)
- DAX Fridays #205: Find values missing in related table ( Download)
- DAX Fridays! #183: How to deal with multiple dates in Power BI ( Download)
- Using SWITCH DAX Function with Multiple Column Values and Expressions in Power BI ( Download)
