Two-Way Lookup in Power Query? M Code for Exact & Approximate Match Lookup. Excel Magic Trick 1554
Download Excel Start File: https://excelisfun.net/files/EMT1554Start.xlsx
Download Excel Finished File: https://excelisfun.net/files/EMT1554Finished.xlsx
Entire page with all Excel Files for All Videos: https://excelisfun.net/files/
In this video learn how to create Power Query M Code formulas for Exact Match and Approximate Match Two Way Lookup.
Topics:
1. (00:06) Introduction
2. (00:40) Exact and Approximate Match Lookup
3. (01:44) Worksheet Exact Match Two-Way Lookup with VLOOKUP & MATCH functions.
4. (04:11) Power Query Exact Match Two-Way Lookup using M Code formulas. Learn M Code Syntax for looking up a Record. Use the Record.Field Function.
5. (10:40) Worksheet Approximate Match Two-Way Lookup using an Array Formula with VLOOKUP & MATCH functions.
6. (13:25) Power Query Approximate Match Two-Way Lookup using M Code formulas. Learn about Custom Functions. Use the Table.AddColumn, Table.SelectRows and List.Last Functions. Learn syntax for Custom Functions, including the each keyword for Custom Functions or explicitly defined M Code Custom Functions. Learn how to create formulas with back to back custom functions.
7. (20:55) Summary
Видео Two-Way Lookup in Power Query? M Code for Exact & Approximate Match Lookup. Excel Magic Trick 1554 канала ExcelIsFun
Download Excel Finished File: https://excelisfun.net/files/EMT1554Finished.xlsx
Entire page with all Excel Files for All Videos: https://excelisfun.net/files/
In this video learn how to create Power Query M Code formulas for Exact Match and Approximate Match Two Way Lookup.
Topics:
1. (00:06) Introduction
2. (00:40) Exact and Approximate Match Lookup
3. (01:44) Worksheet Exact Match Two-Way Lookup with VLOOKUP & MATCH functions.
4. (04:11) Power Query Exact Match Two-Way Lookup using M Code formulas. Learn M Code Syntax for looking up a Record. Use the Record.Field Function.
5. (10:40) Worksheet Approximate Match Two-Way Lookup using an Array Formula with VLOOKUP & MATCH functions.
6. (13:25) Power Query Approximate Match Two-Way Lookup using M Code formulas. Learn about Custom Functions. Use the Table.AddColumn, Table.SelectRows and List.Last Functions. Learn syntax for Custom Functions, including the each keyword for Custom Functions or explicitly defined M Code Custom Functions. Learn how to create formulas with back to back custom functions.
7. (20:55) Summary
Видео Two-Way Lookup in Power Query? M Code for Exact & Approximate Match Lookup. Excel Magic Trick 1554 канала ExcelIsFun
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Mastering the IF Function in Power Query - including Nested-IF statements (Complete Guide)Power Query and Data Validation are Stronger Together Switch Folder and CriteriaMSPTDA 09 Power Query Complete M Code Introduction: Values, let, Lookup, Functions, Parameters, MoreRunning Total in Column, Power Query, DAX or Worksheet Formula? Excel Magic Trick 1553How to Merge Tables with Power Query: VLOOKUP AlternativeHow to use Excel Index Match (the right way)Advanced Excel Power Query - Merge Queries with 3 Lookup ColumnsExcel Magic Trick 1347: Power Query Function: Split Master Table into Sub Tables for Each ProductContext Transition and Tricky ExamplesPower Query Get Previous Row? Stock Price Change Formula. M Code Lookup. Excel Magic Trick 1546MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many RelationshipGet Multiple Files Containing Multiple Sheets with Power QueryHow to easily automate boring Excel tasks with Power Query!Perform a Lookup with Power QueryMSPTDA 10: Power BI M Code for Moving Annual Total (MAT): Custom Function Power Query Custom ColumnMSPTDA 07: Power Query: 6 Types of Joins, 6 Types of Merges: 9 ExamplesPower Query Running Count Based on Row Condition – Excel Magic Trick 1588Excel Hash 2021 - Problem-Solving with LAMBDA, EVEN functions, Dynamic Array Formula & Cutout PersonMSPTDA 05: Power Query: Excel.CurrentWorkbook Function to Append All Excel Tables in Excel Workbook