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_Downloads/BCTI_PQ_COALESCE.xlsx

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