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

[@alexrosen8762]

Extremely powerful and useful tutorial since prices change over time in most organisations so this is a very useful way to handle those changes in a automated way 👌🙏👌

[@aaaexcelenglish]

Glad you liked it, thank you for you nice words

[@zahoorsarbandi2982]

amazing! you have made power query very easy. Thank you for your efforts.

[@aaaexcelenglish]

Thank you so much 😊

[@jaybuddhadev3543]

wonderful, thanks for the easiest way to solve the complicated issue

[@aaaexcelenglish]

Glad it helped! you're welcome

[@agostinhosubtil569]

Excellent exposure. Thank you very much.

[@aaaexcelenglish]

most welcome

[@Altaf_Alam]

Sir plz upload more videos of advanced power query... I am enjoying this series... Your teaching is tip top ❤😊

[@aaaexcelenglish]

Thank you son much for your comment, will do my best to load more

[@radekminarik7417]

Hi, I think your solution is not correct - the price of Mountain Bikes as of December 17. 2019 was valid since November 11, 2019, it was 261.
I would better use:
#"Added Valid PriceList" = Table.AddColumn (#"Merged Queries", "Valid PriceList", (OT) => Table.LastN(Table.SelectRows (PriceList, (IT) => ( ( IT[Date]

[@aaaexcelenglish]

Hi, are you sure that you are commenting on the right video, there is no Moutain bikes in the file related to this video, you should see Product1 & Product2 with much less prices and different dates

[@radekminarik7417]

@@aaaexcelenglish Big apology, the comment should have been on the previous APQ11 video.