In this blog, 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.
SWITCH Function in Power Query
Topics that I write about...
Chandeep
Welcome to Goodly! My name is Chandeep.
On this blog I actively share my learning on practical use of Excel and Power BI. There is a ton of stuff that I have written in the last few years. I am sure you'll like browsing around.
Please drop me a comment, in case you are interested in my training / consulting services. Thanks for being around
Chandeep