Unpivot Data, Merge Tables and Custom Columns - Power Query Challenge 20

In this video, we tackle a common data manipulation task: calculating the total commission for each salesperson and sorting the results in descending order. Using Power Query, we'll demonstrate how to merge sales and commission data from two tables, compute commissions, and organize the output. The challenge includes transforming data with unpivoting, merging tables, and performing calculations.
Whether you're new to Power Query or looking to refine your skills, this step-by-step guide will help you efficiently handle sales data and extract valuable insights.

Timestamps:
00:00 - Introduction
00:18 - Importing tables into Power Query
00:54 - Unpivoting data to establish a common field
01:35 - Merging tables by code
02:01 - Expanding merged data
02:19 - Calculating the total commission
02:42 - Grouping data by name
03:00 - Sorting results
03:06 - Wrap-up and call to action

🔔 Subscribe for more tutorials: [ Ссылка ]

Links:
CHALLENGE AUTHOR: Vijay A. Verma
1) LinkedIn Profile: [ Ссылка ]
2) Power Query Challenge: [ Ссылка ]
3) Download Workbook:
[ Ссылка ]

'Power Query Challenges' Playlist: [ Ссылка ]

#PowerQuery #PowerQueryChallenge #ExcelChallenge #HowToLearnExcel

свернуть