Power Query
published
Search
⌃K

Replacer.ReplaceValue

Replacer.ReplaceValue

Replaces values within the provided input.
function (optional value as nullable any, optional old as nullable any, optional new as nullable any) as nullable 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.

Category

Replacer

Examples

Replace the value 11 with the value 10.
Replacer.ReplaceValue(11, 11, 10)
10