Power BI: Use DAX Switch Function to Make IF Functions Easier

[@danielrafferty4108]

Thanks for this. I am currently doing a dashboard where 23 different code names are used for work accounts and now my boss wants me to give the actual names for these values with the data I have. First thing I thought when I saw the if statement in there was "Oh no, please tell me I don't need to nest all these statements." searched PowerBi dax switch statment and your video was top of the list here. Thanks for quick example! Will be much easier to implement! I'm sure your second measure will come in handy too, the account i'm working on is a bit cowboy with it's support and i'm the only one working on anlytics through Dashboard applications like PowerBI at the moment. I can forsee needing something like this in the future.

[@wapta]

7:00 With SWITCH use TRUE() to evaluate conditions; instead of nested DAX IF statements. Great tip!

[@martinfernandezcean]

This guy explains really well! Thank you

[@PragmaticWorks]

Thank you Martin, we are glad you think so!

[@tianabryant8124]

Thank you! I've subscribed - your explanation helped me to FINALLY make sense of this function for a class I'm taking (after two days). I'm new to DAX and Power BI and your breakdown was much appreciated!

[@PragmaticWorks]

Glad it helped!

[@yasinnadaf2974]

Thank you so much. This video is very useful. Keep making such video

[@PragmaticWorks]

Thank you!!

[@CRAM1REZ51]

Fantasttic!!!!!! Got mi Power BI rolling....!

[@PragmaticWorks]

Glad you enjoyed!

[@ItsWithinYou]

Excellent explanation! Many thanks for sharing!

[@PragmaticWorks]

You're welcome! Glad you enjoyed it!

[@sonpurkesone4072]

Very helpful sir, thanks for the effort

[@PragmaticWorks]

Most welcome!

[@xyclos]

Excellent explanatio. Very detailed!! Thanks a lot!

[@abhinavdiwakar1308]

Brilliant video, so easily to follow.

[@Bhatp9]

Thank you, your videos are invaluable. I must say though that I had to use double quotes even for numeric outputs in the Results value for multiple IF functions.

[@Alberto-dx2sw]

nice video! very useful and concise

[@PragmaticWorks]

Glad it was helpful! Thanks for watching!

[@phinduloneluheni2650]

YOU ARE A GREAT TEACHER ! THANK YOU

[@timewithsopy]

just stumbled to your channel. sub. Thank you. Question. Can I use SWITCH on multiple measures at the same time? That's the dilemma i'm in right now.

[@erinfield1943]

I love a good non-sales-related DAX example.

[@fernandol1611]

¿Se puede combinar SWITH con IF o con otro SWITH ?

[@niitichowdhury6]

Great video

[@channelino24]

Great, learned it. How to use SWITCH with a list of text values? I tried it with IN bit didnt work .. if anyone has an idea, please let me know..

[@mohammedshajith4013]

How about conditional columns easier way right?

[@ahmedismailbinamrai1080]

very helpful, thank you

[@goput7538]

Nice explanation. Would you add, how to combine Swith(true) functions with Min & Max. For ex : The results after multiplier must with MIN and MAX. Need a help.

[@robertravinath6365]

Superb

[@venkatareddykummitha5863]

Suppose i want sorting order of 20 unique customers names in column ( 100000 rows ) by using calculated column. How is that ..

[@prudhvireddy6452]

Good explanation

[@ukaszlachmider5961]

Great tip, especially on how to use expressions instead of constant values!

[@fernandobo9231]

Very helpful

[@PragmaticWorks]

Glad to hear that

[@tisseract]

Switch time = IF( x < 5, 1-x/10) ? there x= Missed Chores

[@demaxsuelmarques6382]

Show!

[@kiroshengovender9791]

Joke had me in stiches