Write if statements like a Pro in Power Query
As the title says, in this video I will show you how to write if-statements like a pro: Chapters 00:00 The ultimate if-statement 00:40 if statement in Excel wont work 01:50 Use power query user interface to write if statement 03:00 Nested if-statements 03:38 AND/OR conditions in if statements 04:48 NOT condition in if statements 05:20 Manage errors in if statements 06:13 Advanced if statements 08:19 Order of evaluation if statements Done! Here you can download all the pbix files: https://curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! / @curbalen Our PLAYLISTS: Join our DAX Fridays! Series: https://goo.gl/FtUWUX Power BI dashboards for beginners: https://goo.gl/9YzyDP Power BI Tips & Tricks: https://goo.gl/H6kUbP Power Bi and Google Analytics: https://goo.gl/ZNsY8l ☼☼☼☼☼☼☼☼☼☼ POWER BI COURSES: Want to learn Power BI? How about you take one of our courses? Here you can find the available courses: https://curbal.com/courses-overview ☼☼☼☼☼☼☼☼☼☼ ABOUT CURBAL: Website: http://www.curbal.com Contact us: http://www.curbal.com/contact ▼▼▼▼▼▼▼▼▼▼ If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running: https://curbal.com/product/sponsor-me Many thanks in advance! ▲▲▲▲▲▲▲▲▲▲ ************ ************ QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: Linkedin ► https://goo.gl/3VW6Ky Twitter ► @curbalen, @ruthpozuelo Facebook ► https://goo.gl/bME2sB #CURBAL #SUBSCRIBE

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

Two-Way Lookup in Power Query? M Code for Exact & Approximate Match Lookup. Excel Magic Trick 1554

Transform Column Names in Bulk in Power Query

Use Excel Like a PRO | Learn Power Query, Power Pivot & DAX in 15 MINUTES (project files included!)

Mastering the IF Function in Power Query - including Nested-IF statements (Complete Guide)

How to write a Multiple (nested) IF in Power Query

Reduce Steps in Power Query - Tips Only the Pros Know!

Getting Started With M Language in Power Query | Basic to Advanced

Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)

Top 10 Power BI Features You Should Be Using Right Now!

How to use Microsoft Power Query

each & underscore_ in Power Query Explained

Power Query was HARD until I learned these 7 Tips

Merging Queries and Understanding Join Kinds in Power Query (Power BI & Excel)

4 METHODS to Filter by a List in Power Query | Excel Off The Grid

Power Query Unpivot - fix 4 common data layouts (incl. workbook)

Reference an Intermediate Step from another Query | Power Query Tricks

Easily Compare Multiple Tables in Power Query

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

