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

• #science_technology
• #coalesce
• #coalesce_operator
• #excel
• #if_then_else
• #power_bi
• #power_query
• #try_otherwise