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;
https://www.computergaga.com
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► https://bit.ly/2Ag5AKH
Excel VBA for Beginners ► http://bit.ly/2JvnnRv
Advanced Excel Tricks ► https://bit.ly/2UlTfvB
Excel Formulas Made Easy ► http://bit.ly/2t3netw
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J
Connect with us!
LinkedIn ► https://www.linkedin.com/company/18737946/
Facebook ► http://www.facebook.com/computergaga
Twitter ► http://www.twitter.com/computergaga1
Видео How to Write an IF Function in Power Query Including Nested IFs канала Computergaga
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;
https://www.computergaga.com
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► https://bit.ly/2Ag5AKH
Excel VBA for Beginners ► http://bit.ly/2JvnnRv
Advanced Excel Tricks ► https://bit.ly/2UlTfvB
Excel Formulas Made Easy ► http://bit.ly/2t3netw
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J
Connect with us!
LinkedIn ► https://www.linkedin.com/company/18737946/
Facebook ► http://www.facebook.com/computergaga
Twitter ► http://www.twitter.com/computergaga1
Видео How to Write an IF Function in Power Query Including Nested IFs канала Computergaga
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Power Query: Index and Modulo FunctionsCreate a Basic Custom Function in Power QueryDAX for Power BI - Nested IF StatementsMeasures vs Calculated Columns - (1.4) Ultimate Beginners Guide to DAX 2019Power Query Merge Queries - VLOOKUP Formula AlternativePower BI Tutorial From Beginner to Pro ⚡ Desktop to Dashboard in 60 Minutes ⏰25 Amazing Power Query Tips and TricksGrouping & Segmenting Your Data With DAX Measure Logic - Advanced DAXPerform a Lookup with Multiple CriteriaPower BI - Conditional columnsPerform a Lookup with Power QueryIF Function in Power QueryEasily Import Data from Web to Excel (2 Practical Examples)Append vs Merge in Power BI and Power QueryDAX Fridays! #78: When should I use FILTER() with CALCULATE?Dealing With Multiple IF Statements In Power BI Using DAXExcel Magic Trick 1349: Power Query with Input Variables from Excel Sheet to Extract RecordsImport Series - Power Query in ExcelCreate A Parameter Table For Your Power QueriesMSPTDA 09 Power Query Complete M Code Introduction: Values, let, Lookup, Functions, Parameters, More