You create the following step by using Power Query Editor. = Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"}) A row has a value of 21318 Lasalle Street in the…

The correct answer is D. 21319 Lasalle Street. Replacer.ReplaceText performs a partial/substring replacement-it finds the text '1318' anywhere within a value and replaces it with '1319'. The value '21318 Lasalle Street' contains the substring '1318', so it becomes '21319 Lasalle Street'. If Replacer.ReplaceValue had been…

Submitted by weili_xi· Apr 18, 2026Prepare the data

Question

You create the following step by using Power Query Editor. = Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"}) A row has a value of 21318 Lasalle Street in the AddressLine1 column. What will the value be when the step is applied?

Options

A1318
B1319
C21318 Lasalle Street
D21319 Lasalle Street

How the community answered

(32 responses)

A
3% (1)
B
9% (3)
C
3% (1)
D
84% (27)

Explanation

Replacer.ReplaceText performs a partial/substring replacement-it finds the text '1318' anywhere within a value and replaces it with '1319'. The value '21318 Lasalle Street' contains the substring '1318', so it becomes '21319 Lasalle Street'. If Replacer.ReplaceValue had been used instead, it would only match the entire cell value '1318' exactly and leave '21318 Lasalle Street' unchanged.

Topics

#Power Query#M language#Table.ReplaceValue#Data transformation

Community Discussion

No community discussion yet for this question.

Full PL-300 Practice