How to Write Power Query if Statements incl. Nested ifs, if or, if and with the IF function

Показать описание

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.

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

💬 Please leave me a COMMENT. I read them all!

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

⏲ 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

Рекомендации по теме

Комментарии

This is what i needed to get into dax or M. Simple way to get me the basics! Great job Mynda 🎉🎉🎉🎉🎉

Seftehandle

The easiest way to learn Excel and power bi from online platform That is you...👌

sankeshsankesh.sawang

I’m really embracing PQ in my new job.
Since learning the basics (mostly from you thank you) this is the first time I’ve used it for real work tasks. I have already dabbled with nested ifs etc. and they are so simple and logical now I’ve done it a few times.
Loads more opportunities for me to clean things up and make processes more efficient using PQ 😀

sjdyt

I was taking my baby steps in Power BI and this nested if then, solved my requirement. Thank you for a detailed explanation.

thiruvallurusrikala

Having a more expressive mechanism (if/then/else vs if/, /, /) makes what you're doing so much more obvious and easier to fix when/if necessary. Microsoft has historically been less-than-helpful in the code-formatting arena (worst example: Access SQL), so preserving whatever formatting you have used is super helpful. Thanks for a nicely-done video!

jackcurl

I love Power Query (Phil told me it would change my life, and he was right), but it has an annoying quirk when it comes to the "if". If I write a "simple if", Power Query will take it upon itself to convert it to a conditional column. This is all very well, unless I was to go back and use a slightly more complex test - the dialogue box is no longer exposed! I know, First World problems ...

Can I suggest that you consider using indenting and multiple lines for your if statements? I feel that it's a good practice, and in my experience can make the statement easier to read. Just a thought.

craigsmall

Great video! You are right, If/And/Or are much easier to write that Excel. Thank you so much for excellent tutorials.

kenmcmillan

Totally agree that conditional functions in PQ are easier than Excel. PQ in also more helpful in finding errors, too.

Quidisi

Thank you so much Mynda, filled a glaring gap in my PQ skills

peterlewis

Thanks for confirming 'null' means blank. Struggled with this recently and figured it out, but nice to know for sure.

davidfamilydoctor

This was excellent and couldn't be more clearly explained, thank you very much for creatings these videos!

aynellrodriguez

you did it again, this open a window of opportunities to improve my process!!

lopher

Hello. I just wanted to say Hi and thank you!! You are an amazing instructor! I have learned so much from you and I cannot wait to learn more! You break down everything very thoroughly to where it is understood. Thank you for your videos!

loriwhittaker