SWITCH Function in Power Query

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/learn-m-powerquery/

✔️ Mastering DAX in Power BI -
https://goodly.co.in/learn-dax-powerbi/

✔️ Power Query Course-
https://goodly.co.in/learn-power-query/

✔️ Master Excel Step-by-Step-
https://goodly.co.in/learn-excel/

✔️ Business Intelligence Dashboards-
https://goodly.co.in/learn-excel-dash...


===== 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/switch-function-...


===== CONTACT 🌐 =====
Twitter - Twitter: chandeep2786
LinkedIn - 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 full-time 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!

• #science_technology
• #goodly
• #chandeep_chhabra
• #power_query_goodly
• #m_language_goodly
• #list_in_power_query
• #switch_function_in_power_query
• #nested_if_in_power_query
• #conditional_logic_in_power_query
• #nested_if_statements_in_power_query
• #conditional_column_in_power_query
• #replace_nested_if_in_power_query