APQ12 | Exact & Approximate Match | Lookup changing Prices & Discount | Advanced Power Query
Автор: ِAAA Excel English
Загружено: 2024-05-03
Просмотров: 4460
#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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
