Table.SelectRows

Returns a table containing only the rows that match a condition.

Table.SelectRows(table as table, condition as function) as table

Arguments

Argument Description
table The Table to check.
condition The condition to match.

Remarks

  • Table. SelectRows is similar to List. Select but requires a table as input.

Examples

Table.SelectRows(Table.FromRecords({[A=1], [A=2], [A=3]}), each [A] > 2) equals Table.FromRecords({[A=3]})

 
 
Applies to:
Excel 2013, Excel 2010