You have a column "Status" with values "Open", "Closed", and "Pending". You want to replace "Open" with "Started" and "Closed" with "Finished" in a single Power Query step. Which method is best?

hard📝 Scenario Q8 of 15

Power BI - Power Query Editor

AUse nested Table.ReplaceValue calls, one for each replacement

BUse a single Table.ReplaceValue with a list of old and new values

CCreate a mapping table and merge it with the original table

DUse Table.TransformColumns with a custom function to replace values

Step-by-Step Solution

Solution:

Step 1: Understand limitations of Table.ReplaceValue
Table.ReplaceValue replaces one value at a time; multiple replacements require multiple calls.
Step 2: Efficient approach
Using Table.TransformColumns with a custom function allows multiple replacements in one step.
Final Answer:
Use Table.TransformColumns with a custom function to replace values -> Option D
Quick Check:
Custom functions handle multiple replacements efficiently [OK]

Quick Trick: Use TransformColumns with function for multiple replacements [OK]

Common Mistakes:

Trying to replace multiple values in one Table.ReplaceValue call
Not using a mapping table when appropriate
Ignoring custom functions for complex replacements

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 column "Status" with values "Open", "Closed", and "Pending". You want to replace "Open" with "Started" and "Closed" with "Finished" in a single Power Query step. Which method is best?

Step 1: Understand limitations of Table.ReplaceValue

Step 2: Efficient approach

Final Answer:

Quick Check:

Want More Practice?