APQ11 | Merge Queries - 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 https://www.youtube.com/playlist?list=PL5NlUYOM2iOjRsboi_z9cHTyM7yqwWu58 --------------------------------------------------------------------- To download the working files: https://drive.google.com/drive/folders/1OOAmDYiQujLbNyZ3MtVP_se3qZBBDRYb?usp=drive_link --------------------------------------------------------------------- To subscribe: https://www.youtube.com/channel/UCAxOgfPN8XqlB-lGmORVB5g?sub_confirmation=1 --------------------------------------------------------------------- To follow on Facebook: https://www.facebook.com/excelispower --------------------------------------------------------------------- To follow on LinkedIn: https://www.linkedin.com/in/amratef