APQ12 | Exact & Approximate Match | Lookup changing Prices & Discount | Advanced Power Query

#excel #exceltutorial #powerquery #m_code
---------------------------------------------------------------------
Visit the website: www.aaa-power.net
---------------------------------------------------------------------
Chapters:
0:00 Intro
1:01 Example Overview
3:09 Lookup correct price (Table.SelectRows - List.Last)
11:07 Aggregate Monthly Quantity (Group By)
12:42 Lookup proper discount (Table.SelectRows - List.Max - Merge Queries)
18:09 Calculate Revenue (Number.Round)
21:46 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