Power BI - Power Query Editor
Which Power Query M code snippet correctly replaces the value "Pending" with "Completed" in the column "OrderStatus"?
Which Power Query M code snippet correctly replaces the value "Pending" with "Completed" in the column "OrderStatus"?
easy📝 Conceptual Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Syntax for Table.ReplaceValue
The function requires the source table, old value, new value, replacer function, and a list of columns.Step 2: Check parameters
Table.ReplaceValue(Source, "Pending", "Completed", Replacer.ReplaceText, {"OrderStatus"}) correctly specifies all parameters including the column list as {"OrderStatus"}.Final Answer:
Table.ReplaceValue(Source, "Pending", "Completed", Replacer.ReplaceText, {"OrderStatus"}) -> Option BQuick Check:
Correct syntax includes column list in braces [OK]
Quick Trick: Always specify columns as a list in braces [OK]
Common Mistakes:
- Omitting the column list
- Swapping old and new values
- Passing column name instead of old value
Master "Power Query Editor" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes