[Solved] Given a table with columns Product, Sales, Date, what will be the column order after applying this Power Query step?Table.ReorderColumns(Source, {"Date", "Product", "Sales"}) | Power BI

Power BI - Power Query Editor

Given a table with columns Product, Sales, Date, what will be the column order after applying this Power Query step?
Table.ReorderColumns(Source, {"Date", "Product", "Sales"})

ADate, Product, Sales

BProduct, Sales, Date

CSales, Date, Product

DProduct, Date, Sales

Step-by-Step Solution

Solution:

Step 1: Understand Table.ReorderColumns
This function changes the column order to the list provided.
Step 2: Apply given order
The list is {"Date", "Product", "Sales"}, so columns reorder exactly in that sequence.
Final Answer:
Date, Product, Sales -> Option A
Quick Check:
ReorderColumns sets column order as listed [OK]

Quick Trick: ReorderColumns sets columns exactly as listed [OK]

Common Mistakes:

Assuming original order stays
Mixing column names order
Ignoring the reorder list

Master "Power Query Editor" 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 a table with columns Product, Sales, Date, what will be the column order after applying this Power Query step?

Step 1: Understand Table.ReorderColumns

Step 2: Apply given order

Final Answer:

Quick Check:

Want More Practice?