Table.ReplaceMatchingRows(table as table, replacements as list, optional equationCriteria as any) as table


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

Power Query M Functions / Table Functions / Table.ReplaceMatchingRows