APQ11 | Merge Quires - Next Level |Merge | M-Code | Custom Column | Records | Advanced Power Query 

#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:
drive.google.com/drive/folder...
---------------------------------------------------------------------
To subscribe:
/ @aaaexcelenglish
---------------------------------------------------------------------
To follow on Facebook:
/ excelispower
---------------------------------------------------------------------
To follow on LinkedIn:
/ amratef

Наука