Mimic a SWITCH function in Power Query using Record.FieldOrDefault

The SWITCH function allows users to map input values to corresponding output values. In this video, you learn how to apply this concept in Power Query by using Record.FieldOrDefault You can buy the Definitive Guide to Power Query M here: https://geni.us/ODZl8 WRITTEN ARTICLE: https://gorilla.bi/power-query/switch/ Master Functions and Syntax in M https://powerquery.how ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. Website: https://gorilla.bi SUBSCRIBE TO MY CHANNEL https://youtube.com/bigorilla?sub_confirmation=1 TIMESTAMPS 00:00 Introduction 00:19 The manual way 01:47 Understanding SWITCH 02:29 Using Record.FieldOrDefault 05:52 Taking a table as input LET'S CONNECT: Blog: https://gorilla.bi Facebook: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #switch #powerquery #bigorilla