Power Query Secrets: Use coalesce (??) to handle null values

★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ Get the example file ★ Sign up for our free Insiders program and get the example file: https://exceloffthegrid.com/insiders-... File Reference for this video: 0228 Coalesce in Power Query.zip ★ About this video ★ In this video, we look at how to handle null values in Power Query by using the coalesce operator (??) 0:00 Introduction 0:32 Download example file 0:47 Example 1 2:12 What does coalesce do? 3:13 Example 2 4:04 Example 3 5:29 Example 4 6:23 Wrap up ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter:   / exceloffthegrid   #MsExcel