Which steps correctly achieve this pivot in Power Query?
hard📝 Scenario Q15 of 15
Power BI - Data Cleaning with Power Query
You have sales data with columns: Region, Product, Month, and Sales. You want a table showing each Region as rows and each Month as columns with total Sales. Which steps correctly achieve this pivot in Power Query?
ASelect Month column -> Pivot Columns -> Choose Sales as values -> Select Sum as aggregation
BSelect Region column -> Unpivot Columns -> Choose Sales as values -> Select Average as aggregation
CSelect Product column -> Pivot Columns -> Choose Sales as values -> Select Count as aggregation
DSelect Sales column -> Pivot Columns -> Choose Month as values -> Select Sum as aggregation
Step-by-Step Solution
Solution:
Step 1: Identify pivot column and values
You want Months as columns, so select the Month column to pivot. Sales are the values to aggregate.
Step 2: Apply pivot with correct aggregation
Use 'Pivot Columns' on Month, choose Sales as values, and Sum aggregation to total sales per Region and Month.
Final Answer:
Select Month column -> Pivot Columns -> Choose Sales as values -> Select Sum as aggregation -> Option A
Quick Check:
Pivot Month with Sales sum = correct approach [OK]
Quick Trick:Pivot Month column, aggregate Sales by Sum [OK]
Common Mistakes:
Pivoting wrong column (Region or Product)
Using Unpivot instead of Pivot
Choosing wrong aggregation like Count or Average
Master "Data Cleaning with Power Query" in Power BI
9 interactive learning modes - each teaches the same concept differently
