[Solved] What will be the result of this Power Query M code?let Source = Table.FromRecords({[Product="Pen", Price=1],[Product="Pencil", Price=0.5]}), Replaced = Table.ReplaceValue(Source, 0.5, 0.75, Replacer.... | Power BI

Power BI - Power Query Editor

What will be the result of this Power Query M code?

let
  Source = Table.FromRecords({[Product="Pen", Price=1],[Product="Pencil", Price=0.5]}),
  Replaced = Table.ReplaceValue(Source, 0.5, 0.75, Replacer.ReplaceValue, {"Price"})
in
  Replaced

APrice for Pencil changes to 0.75

BPrice for Pen changes to 0.75

CNo change in prices

DError due to wrong replacer function

Step-by-Step Solution

Solution:

Step 1: Identify the value to replace and the replacer function
The code replaces 0.5 with 0.75 in the Price column using Replacer.ReplaceValue.
Step 2: Check which row has Price 0.5
Pencil has Price 0.5, so it will be updated to 0.75.
Final Answer:
Price for Pencil changes to 0.75 -> Option A
Quick Check:
ReplaceValue updates numeric values correctly [OK]

Quick Trick: Use Replacer.ReplaceValue for numeric replacements [OK]

Common Mistakes:

Using Replacer.ReplaceText for numbers
Expecting Pen's price to change
Thinking no change occurs

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

What will be the result of this Power Query M code?

Step 1: Identify the value to replace and the replacer function

Step 2: Check which row has Price 0.5

Final Answer:

Quick Check:

Want More Practice?