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