Creating a SWITCH Function with Conditions in Power Query M
The SWITCH function allows users to provide multiple conditions and return the corresponding value when one of these evaluates to true. In this video, you learn how to apply this concept in Power Query.
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:33 Scenario
01:02 List of Conditions
03:35 Retrieving Conditions and Results
05:21 Find and return the first true condition
08:24 Setting up default value logic
12:16 Applying logic to column
12:57 Create a custom SWITCH function
LET'S CONNECT:
Blog: https://gorilla.bi
Facebook: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / rickmaurinus
Thank you for your support!
#switch#powerquery #bigorilla