Table.ReplaceMatchingRows

This function will update all the designated rows in the table with the rows provided. The rows to be replaced and the replacement values are indicated in the 'replacements' parameter, using the format {old, new}. If needed, an optional 'equationCriteria' parameter can be included to determine how the rows in the table are compared.

Substitute the rows [a = 1, b = 2] and [a = 2, b = 3] with [a = -1, b = -2],[a = -2, b = -3] in the table. This can be done using Power Query MTable.ReplaceMatchingRows function, where the initial table is provided as Table.FromRecords with records [a = 1, b = 2], [a = 2, b = 3], [a = 3, b = 4], [a = 1, b = 2]. The replacements are specified in pairs {[a = 1, b = 2], [a = -1, b = -2]} and {[a = 2, b = 3], [a = -2, b = -3]}. The output table will be generated using Table.FromRecords containing records [a = -1, b = -2], [a = -2, b = -3], [a = 3, b = 4], [a = -1, b = -2].