If you come from an Excel background, just like most of the Power BI users including myself, you are probably used to writing complex IF statements. Now, with Power BI, there is a far more superior logic to do this; and, that is through the SWITCH TRUE LOGIC. This has been discussed in the Enterprise DNA Forum multiple times and I just want to run a quick recap on how to have a better solution than using multiple IF Statements.

***** Video Details *****
2:07 using SWITCH TRUE LOGIC instead of IF Statement
3:27 SWITCH format
3:44 using ampersand “&” to have multiple evaluations in every single row

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

Read More

Share This