You have a table with columns ID, Name, Age, and Salary. You want to remove Age, rename Salary to Income, and reorder columns so Name comes first. Which sequence of Power Query steps is correct?

hard📝 Scenario Q15 of 15

Power BI - Power Query Editor

You have a table with columns ID, Name, Age, and Salary. You want to remove Age, rename Salary to Income, and reorder columns so Name comes first. Which sequence of Power Query steps is correct?

ARemove <code>Age</code>, Rename <code>Salary</code> to <code>Income</code>, Reorder columns to ["Name", "ID", "Income"]

BRename <code>Salary</code> to <code>Income</code>, Remove <code>Age</code>, Reorder columns to ["ID", "Name", "Income"]

Reorder columns to ["ID", "Name", "Salary", "Age"], Remove <code>Age</code>, Rename <code>Salary</code> to <code>Income</code>

DRemove <code>Name</code>, Rename <code>Age</code> to <code>Income</code>, Reorder columns to ["ID", "Salary"]

Step-by-Step Solution

Solution:

Step 1: Remove the Age column
First, remove the unwanted Age column to exclude it from the table.
Step 2: Rename Salary to Income
Next, rename the Salary column to Income for clarity.
Step 3: Reorder columns with Name first
Finally, reorder columns so Name is first, followed by ID and Income.
Final Answer:
Remove Age, Rename Salary to Income, Reorder columns to ["Name", "ID", "Income"] -> Option A
Quick Check:
Remove, Rename, Reorder in that order [OK]

Quick Trick: Remove unwanted, rename needed, reorder last [OK]

Common Mistakes:

Reordering before removing columns
Renaming wrong columns
Removing needed columns by mistake

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

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

More Power BI Quizzes

You have a table with columns ID, Name, Age, and Salary. You want to remove Age, rename Salary to Income, and reorder columns so Name comes first. Which sequence of Power Query steps is correct?

Step 1: Remove the `Age` column

Step 2: Rename `Salary` to `Income`

Step 3: Reorder columns with `Name` first

Final Answer:

Quick Check:

Want More Practice?

You have a table with columns ID, Name, Age, and Salary. You want to remove Age, rename Salary to Income, and reorder columns so Name comes first. Which sequence of Power Query steps is correct?

Step 1: Remove the Age column

Step 2: Rename Salary to Income

Step 3: Reorder columns with Name first

Final Answer:

Quick Check:

Want More Practice?

Step 1: Remove the `Age` column

Step 2: Rename `Salary` to `Income`

Step 3: Reorder columns with `Name` first