Table.RemoveMatchingRows
Deletes all instances of the specified rows from the table. A parameter called equationCriteria can be optionally included to determine how the rows are compared in the table.
Table.RemoveMatchingRows(table as table, rows as list, optional equationCriteria as any) as tableDeletes all instances of the specified rows from the table. A parameter called equationCriteria can be optionally included to determine how the rows are compared in the table.
Omit any rows where the value of 'a' is equal to 1 from the specified table ([a = 1, b = 2], [a = 3, b = 4], [a = 1, b = 6]). This action can be achieved using the Power Query M function MTable.RemoveMatchingRows(). The function requires the input table which is created using Table.FromRecords() method with the specified rows. The condition to remove rows where 'a' equals 1 is provided as {[a = 1]}. Finally, the output table excluding the rows where 'a' is equal to 1 will be displayed as [a = 3, b = 4].