How to Write an IF Function in Power Query Including Nested IFs

The IF function is one of the most useful in Excel. In this video we look at how to write an IF function in Power Query.

The video includes three examples. Firstly a typical IF function added as a custom column. Then we combine the If function with Or logic. Then we finish we a nested IF example.

The video will cover the key differences between writing formulas in Power Query and in worksheets.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[michalroesler]

Thanks Alan.
And the humor is top notch as well. Doing all this with such an ease.

[patticmcconnell]

I have to tell you that this is by far the best video explaining IF functions for a power query. I searched hours I should have known to look you up! Always such great content!

[allabout]

Wery good spent 11 minutes. Good, simple and clear explanation, straight to the point. Man is big pleasure to be You subscriber. Thanks!

[christianlira]

SImply brilliant how you build-up from basic to nested, with logical reasoning and humor. You achieved teaching me the building blocks and why it works, including syntax CAPS et.al. Thank you!

[wayneedmondson]

Hi Alan.. very nice video on writing IF Functions in Power Query and an intro to M Code. Thanks to your excellent VBA course, the structure and syntax was familiar and easy to understand. Looking forward to more videos like this in 2019. Thanks and Thumbs up!

[luizalmeida]

Thank you very much. Very simple now, after this tutorial. Greetings from Brasil.

[amiltonnhaca]

This is very usefull. Thank you Computerga. I already subscribed in your chanel and I will spread this knowledge.

[RafaelSouza-oxdd]

Thanks, it helps me with IF function!
God bless u

[rdaleprice]

Very easy to follow and understand. Thank you for creating the excellent video!

[francescacolonnello]

Thank you so much, you just made my day as I didn't know how to overcome the limits of the conditional column and now I can rely on a custom one to build my IF and nested IFs with ease. Thanks for the clarity of the explanation.
Best regards.

[anhtiennguyenvu]

thank you. your video help me so much. i have just changed my work and i need to learn more about power query. i am doing a report that using many many if, and, or funtion. i dont know how to do it, but finally i have found your video :)))

[sasavienne]

Excellent and so easy to understand thanks to your brilliant way of explaining each single step. Thank you. 👍

[laissezfairez]

I computer Gaga, I love you, you are very smart :)

[MarciusMGSouza]

Very nice and clear explanations. Thanks a lot!

[dorotatopolniak]

Thank you - great explanatory video going through different options for If function in Power Query. You saved my day!

[ronniebrito]

thank you so much, i was searching for this example, i couldn't find neither on documentations.

[adamburnett]

an excellent tutorial well paced and easy to understand - thank you.

[ahmad-matar]

It is worthy for watching many times.
I would ask about complex condition when using several "or" and "and" in one condition.
Thanks in advance

[luisangelgarciacasas]

Thanks amigo from Mexico City! I found exactly what I was looking for, great video.

[agermoune]

Glad I found your video. Power BI and Microsoft need to do a better job in the help section. they should put example of each Fx just like Tableau... Thx again for taking time to post