Replacer.ReplaceValue

Replacer.ReplaceValue is a Power Query M function that replaces the old value in the original value with the new value. The function returns a replacer function for use in List.ReplaceValue and Table.ReplaceValue.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Replacer.ReplaceValue(
   value as any,
   old as any,
   new as any,
) as any

Description

Replaces the old value in the original value with the new value. This replacer function can be used in List.ReplaceValue and Table.ReplaceValue.

Examples

Replace the value 11 with the value 10.

// Output: 10
Replacer.ReplaceValue( 11, 11, 10 )

Used by

While the Replacer.ReplaceValue function can be used on its own, it is also used by the following functions:

• List.ReplaceValue
• Table.ReplaceValue

Related functions

Other functions related to Replacer.ReplaceValue are:

• Replacer.ReplaceText

Last update: November 17, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/replacer-replacevalue
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.