List.ReplaceValue

Syntax

List.ReplaceValue(list as list, oldValue as any, newValue as any, replacer as function) as list

Description

Searches a list of values, list, for the value oldValue and replaces each occurrence with the replacement value newValue.

Reference Data

https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

Power Query M Functions / List Functions / List.ReplaceValue