You have a sales table with months as columns and products as rows. You want to create a report showing sales by month vertically. Which sequence of Power Query steps correctly achieves this?

hard📝 Scenario Q8 of 15

Power BI - Data Cleaning with Power Query

AAdd a calculated column for month, then group by product

BFilter rows by month, then sort by product

CMerge the table with itself, then transpose

DUse Table.Transpose to flip the table, then promote first row as headers

Step-by-Step Solution

Solution:

Step 1: Identify the goal
You want months as rows (vertical), so flipping columns to rows is needed.
Step 2: Apply transpose and fix headers
Transpose flips rows and columns. Then promote first row (original column headers) as new headers for clarity.
Final Answer:
Use Table.Transpose to flip the table, then promote first row as headers -> Option D
Quick Check:
Transpose + promote headers = vertical months [OK]

Quick Trick: Transpose then promote headers to reshape data [OK]

Common Mistakes:

Filtering or grouping instead of transposing
Merging tables unnecessarily
Not promoting headers after transpose

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

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

More Power BI Quizzes

You have a sales table with months as columns and products as rows. You want to create a report showing sales by month vertically. Which sequence of Power Query steps correctly achieves this?

Step 1: Identify the goal

Step 2: Apply transpose and fix headers

Final Answer:

Quick Check:

Want More Practice?