#excel #exceltutorial #powerquery #m_code
---------------------------------------------------------------------
Visit the website: www.aaa-power.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