[Solved] Given this Power Query M code:let Source = Table.FromRecords({[Name="Anna", City="NY"],[Name="Bob", City="LA"]}), Replaced = Table.ReplaceValue(Source, "LA", "Los Angeles", Replacer.... | Power BI

Power BI - Power Query Editor

Given this Power Query M code:

let
  Source = Table.FromRecords({[Name="Anna", City="NY"],[Name="Bob", City="LA"]}),
  Replaced = Table.ReplaceValue(Source, "LA", "Los Angeles", Replacer.ReplaceText, {"City"})
in
  Replaced

What will be the value in the City column for Bob after this code runs?

ALA

BNY

CLos Angeles

Dnull

Step-by-Step Solution

Solution:

Step 1: Understand the ReplaceValue function in the code
The code replaces "LA" with "Los Angeles" in the City column.
Step 2: Check Bob's City value before and after replacement
Bob's City is "LA", so it will be replaced with "Los Angeles".
Final Answer:
Los Angeles -> Option C
Quick Check:
ReplaceValue changes "LA" to "Los Angeles" [OK]

Quick Trick: ReplaceValue changes matching values only in specified columns [OK]

Common Mistakes:

Assuming no change happens
Confusing column names
Thinking replacement affects other columns

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 this Power Query M code:

Step 1: Understand the ReplaceValue function in the code

Step 2: Check Bob's City value before and after replacement

Final Answer:

Quick Check:

Want More Practice?