List.ReplaceMatchingItems

Syntax

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

Description

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

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

Power Query M Functions / List Functions / List.ReplaceMatchingItems