excelisfun | Approximate Match Lookup in Power Query: 2 Amazing Functions! Power BI or Excel. EMT 1865 @excelisfun | Uploaded 1 month ago | Updated 2 days ago
Download Excel File: https://excelisfun.net/files/EMT1865.xlsx
Learn how to perform approximate match lookup in Power Query M Code by creating custom functions. The first function we build in a Custom Column using the Table.SelectRows function and the let expression. The second we build as a reusable function in the Advanced Editor using the Table.SelectRows function. The third we build as a reusable function in the Advanced Editor using the List.Accumulate function.

M Code book from excelisfun at Mr Excel Site: https://www.mrexcel.com/products/the-transformative-magic-of-power-query-m-code-in-excel-and-power-bi/

M Code book from excelisfun at Amazon: https://www.amazon.com/Transformative-Magic-Power-Query-Excel/dp/1615470832/ref=sr_1_1

The M Code book is Mike "excelisfun" Girvin's 4th book: The Transformative Magic of Power Query M Code in Power BI & Excel: the book about Power Query M Code to help data analysts transform and shape data into useful, actionable information for decision makers.

Topics:
1. (00:00) Introduction
2. (00:04) Approximate Match Lookup
3. (00:45) Custom Column with Table.SelectRows function & the let expression solution
4. (06:08) Table.SelectRows function in Re-usable function solution
5. (09:08) List.Accumulate function solution.
6. (12:48) Summary
7. (13:22) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #powerquery #mcode #lookup