Solution:Step 1: Understand pivot operation on given dataPivoting 'Month' turns Jan and Feb into columns. Sales values are summed per Product.Step 2: Find Sales for Product B in FebProduct B has 250 sales in Feb, so the pivoted 'Feb' column for Product B is 250.Final Answer:250 -> Option DQuick Chec

[Solved] Given this table:Product | Month | Sales A | Jan | 100 A | Feb | 150 B | Jan | 200 B | Feb | 250If you pivot the 'Month' column with 'Sales' as values and sum aggregation, what will be the value in... | Power BI

Power BI - Data Cleaning with Power Query

Given this table:

Product | Month | Sales
A       | Jan   | 100
A       | Feb   | 150
B       | Jan   | 200
B       | Feb   | 250

If you pivot the 'Month' column with 'Sales' as values and sum aggregation, what will be the value in the 'Feb' column for Product B?

A150

B100

C350

D250

Step-by-Step Solution

Solution:

Step 1: Understand pivot operation on given data
Pivoting 'Month' turns Jan and Feb into columns. Sales values are summed per Product.
Step 2: Find Sales for Product B in Feb
Product B has 250 sales in Feb, so the pivoted 'Feb' column for Product B is 250.
Final Answer:
250 -> Option D
Quick Check:
Sum of Sales for Product B in Feb = 250 [OK]

Quick Trick: Sum values per product after pivoting months [OK]

Common Mistakes:

Adding sales of Jan and Feb incorrectly
Mixing product sales values
Choosing the wrong aggregation

Master "Data Cleaning with Power Query" in Power BI

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Sheet Try Challenge Scenario Recall Dash

More Power BI Quizzes

Given this table:

Step 1: Understand pivot operation on given data

Step 2: Find Sales for Product B in Feb

Final Answer:

Quick Check:

Want More Practice?