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