Power Query if statements using the Power Query if function are easier to write than those in Excel. In this video I'll teach you how to write them in both Excel and Power BI using the Custom Column tool and write Power Query if and, if or, and nested if statements.
🔻 DOWNLOAD EXCEL FILE HERE: www.myonlinetr...
🎓 LEARN MORE in my Power Query course: www.myonlinetr...
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetr...
⏲ TIMESTAMPS
0:00 How to write if Statements in Power Query
0:29 Power Query if statements with Conditional Column
1:42 Power Query if statements with Custom Column
2:29 Power Query if or statements
3:52 Power Query if and statements
4:53 Power Query nested if statements
6:27 File Download Link
Негізгі бет How to Write Power Query if Statements incl. Nested ifs, if or, if and with the IF function
No video
Пікірлер: 136