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