Mastering the IF Function in Power Query - including Nested-IF statements (Complete Guide)
Автор: BI Gorilla
Загружено: 2020-07-13
Просмотров: 140595
Master the if function. Learn about its syntax, get if statement examples and understand what errors you can bump into.
Master Functions and Syntax in M
https://powerquery.how
0:00 Introduction
0:41 The data set
1:06 Your first if-statement
2:38 Differences with Excel
4:01 Using Conditional Column
8:45 Logical operators
9:18 Nested if-statements
13:45 Using multiple conditions
19:00 An alternative to OR
20:52 Errors in Power Query
WRITTEN ARTICLE:
https://gorilla.bi/power-query/if-fun...
ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.
SUPPORT MY CHANNEL
Any videos are made free of charge. You can support my channel by giving a donation through: https://paypal.me/rickmaurinus.
Website: https://gorilla.bi
SUBSCRIBE TO MY CHANNEL
https://youtube.com/bigorilla?sub_con...
LET'S CONNECT:
Blog: https://gorilla.bi
Facebook: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / rickmaurinus
Thank you for your support!
#PowerQuery #IfFunction #BIGorilla
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
