#excel #exceltutorial #powerquery #m_code

Visit the website: www.aaapower.net

Chapters:
0:00 Intro
2:11 Pricing Criteria example
4:49 Add Columns to Prepare the tables for the MERGE
6:29 Perform Left Outer MERGE based on 3 matching columns
8:36 Extract Max Price without and the expand step (List.Max)
11:39 Create a RECORD inside a Custom Column (List.Min List.Average)
15:46 Table.Sort List.First List.Last
20:27 Close

To watch the full Playlist
   • Advanced Power Query  

To download the working files:
https://drive.google.com/drive/folder...

To subscribe:
   / @aaaexcelenglish  

To follow on Facebook:
  / excelispower  

To follow on LinkedIn:
  / amratef