List.ReplaceMatchingItems(list as list, replacements as list, optional equationCriteria as any) as list


Performs the given replacements to the list list. A replacement operation replacements consists of a list of two values, the old value and new value, provided in a list. An optional equation criteria value, equationCriteria, can be specified to control equality testing.

Reference Data

Power Query M Functions / List Functions / List.ReplaceMatchingItems