Syntax
Table.ReplaceMatchingRows(table as table, replacements as list, optional equationCriteria as any) as table
Description
Replaces all the specified rows in the table with the provided ones. The rows to replace and the replacements are specified in replacements, using {old, new} formatting. An optional equationCriteria parameter may be specified to control comparison between the rows of the table.
Reference Data
https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference