Power Query - COALESCE Operator (Shorten those formulas with a cool "mystery" operator)
Learn how to write more efficient formulas using the COALESCE operator when dealing with NULLs in the source data. This is a great way to shorten If...Then...Else statements as well as Try...Otherwise statements. File Download Link: https://www.bcti.com//wp-content/YT_D... 00:49 File Download Instructions 00:58 Problems when working with NULLs 02:22 Detecting and Replacing Missing Data 06:18 Using COALESCE to Replace IF...THEN...ELSE Statements 09:37 Conclusion
▶︎
Power Query - Import Fixed Width (Delimited) Files
▶︎
Power Query - Query Folding (The key to faster query execution)
▶︎
I Bet You Didn’t Know Power Query Could Do This (7 Tricks)
▶︎
Power Query - Avoid "Helper Queries" (+10 Cool Tricks)
▶︎
Microsoft Excel & Power Query - Dynamic Plain Table Ranges (Using TRIMRANGE - Dot Operator)
▶︎
One Excel Formula. 9,000 Rows. One Thing to TRUST.
▶︎
Power Query - Unlimited Formulas in 1 Step
▶︎
Avoid Power Query Failures: The Smart Way to Manage Column Names
▶︎
Power Query Unpivot - fix 4 common data layouts (incl. workbook)
▶︎
Power Query - GROUPBY Comparer Function Argument (Creating Bin Ranges)
▶︎
Power Query - Preserve Post-Query Columns (i.e., Notes Column)
▶︎
Power Query Secrets: Use coalesce (??) to handle null values
▶︎
Do-While Loop in Power Query with List.Generate
▶︎
How to easily automate boring Excel tasks with Power Query!
▶︎
I Bet You Don't Know All These Power Query Tricks
▶︎
Refresh breaks due to COLUMN NAME CHANGES? 3 ways to fix changing column headers in Power BI!
▶︎
Power Query - Parameters with Error Checking (with bonus tip)
▶︎
Nested Lists in Power Query: You’ll Wish You Knew This Sooner
▶︎
7 Power Query Tricks You’ll Regret Not Knowing
▶︎