How to write a Multiple (nested) IF in Power Query

⏬ Click to check out the description for info and links⏬ I show 2 methods to write a multiple IF formula in Power Query including using an "Approximate Match" method 00:00 Intro 00:34 The Setup and Goal 01:24 A better way of writing a nested IF 06:54 How to do an Approximate Match in Power Query Download the file https://aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/ErZBuabRGzRHkcnvx-025xMBewh7kVPDLBNyDO3NMCQ45A?e=AEJ7k4 Did you know I've written a book "Power BI for the Excel Analyst"? https://pbi.guide/book/ Connect with me https://wyn.bio.link/ https://accessanalytic.com.au/