Name: How to write a Multiple (nested) IF in Power Query | 影片 | 乾淨世界
Uploaded: 2023-12-09T13:31:00.463Z
Duration: 9 min 50 s
Description: ⏬ 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" ... | 影片 | 乾淨世界

Access Analytic

https://video2-us-east.cloudokyo.cloud/video/v6/5e/e0/d2/5ee0d20a-df54-47ef-acc2-161124b492e9/master.m3u8

⏬ 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/