[Solved] You wrote this code to replace "NY" with "New York" in the City column:Table.ReplaceValue(Source, "NY", "New York", Replacer.ReplaceText)But it gives an error. What is missing? | Power BI

Power BI - Power Query Editor

You wrote this code to replace "NY" with "New York" in the City column:

Table.ReplaceValue(Source, "NY", "New York", Replacer.ReplaceText)

But it gives an error. What is missing?

AThe old value to replace

BThe source table variable

CThe replacer function

DThe list of columns to apply replacement to

Step-by-Step Solution

Solution:

Step 1: Review Table.ReplaceValue syntax
The function requires source, old value, new value, replacer, and columns list.
Step 2: Identify missing argument in code
The code lacks the list of columns to apply replacement, causing error.
Final Answer:
The list of columns to apply replacement to -> Option D
Quick Check:
Columns list is mandatory in ReplaceValue [OK]

Quick Trick: Always specify columns as a list in ReplaceValue [OK]

Common Mistakes:

Master "Power Query Editor" in Power BI

9 interactive learning modes - each teaches the same concept differently

More Power BI Quizzes

You wrote this code to replace "NY" with "New York" in the City column: