← Back to Replacer functions

Replacer.ReplaceValue

The replacer function replaces the original value with the new value. It is suitable for use in List.ReplaceValue and Table.ReplaceValue functions.

Syntax

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

About

The replacer function replaces the original value with the new value. It is suitable for use in List.ReplaceValue and Table.ReplaceValue functions.

Explanation

Substitute the value 11 with the value 10. Employ the Power Query MReplacer.ReplaceValue(11, 11, 10) function to achieve this change. The resulting output will be 10.