List.ReplaceValue Function in Power Query
The List.ReplaceValue function searches a list of values for the value and replaces each occurrence with the replacement value.
Syntax
List.ReplaceValue(list as list, oldValue as any, newValue as any, replacer as function) as list
Example:
Power Query M
let
Source = {"India", "America", "Canada", "Japan", "Australia", "England", "Canada"},
Return = List.ReplaceValue(Source, "Canada", "Canadian", Replacer.ReplaceText)
in
Return The output will be shown in the following image:
