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_con...

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: Facebook: BIGorilla
Twitter: Twitter: rickmaurinus
LinkedIn: LinkedIn: rickmaurinus

Thank you for your support!

#switch #powerquery #bigorilla

• #education
• #power_query_if_statement
• #power_query_switch_map_values
• #power_query_m_if_function
• #power_query_ifs
• #power_query_multiple_if_statements
• #recordfieldordefault