• The Magic of Working with Lists in Po...  

In this video, I'll show you a simple way to imitate the SWITCH function in Power Query. Since Power Query doesn't have this function, I'll demonstrate an easy technique that mimics it, helping you avoid complex nested IF statements.
#PowerQuery #DataCleaning #NestedIf

===== ONLINE COURSES =====
✔ Master 'M' in Power Query
https://goodly.co.in/learnmpowerquery/

✔ Mastering DAX in Power BI
https://goodly.co.in/learndaxpowerbi/

✔ Power Query Course
https://goodly.co.in/learnpowerquery/

✔ Master Excel StepbyStep
https://goodly.co.in/learnexcel/

✔ Business Intelligence Dashboards
https://goodly.co.in/learnexceldash...


===== LINKS =====
Blog https://www.goodly.co.in/blog/
Corporate Training ‍ https://www.goodly.co.in/training/
Need my help on a Project https://www.goodly.co.in/consulting/
Download File ⬇ https://goodly.co.in/switchfunction...


===== CONTACT =====
Twitter   / chandeep2786  
LinkedIn   / chandeepchhabra  
Email [email protected]


===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my fulltime venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!