Table.SelectRows
TOC
Collapse the table of content
Expand the table of content

Table.SelectRows

 

This topic applies to the Power Query Formula Language (informally known as "M") which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.

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

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

ArgumentDescription
tableThe Table to check.
conditionThe condition to match.
  • Table. SelectRows is similar to List. Select but requires a table as input.
Table.SelectRows(Table.FromRecords(  
  
{  
  
      [CustomerID = 1, Name = "Bob", Phone = "123-4567"],  
  
      [CustomerID = 2, Name = "Jim", Phone = "987-6543"] ,  
  
      [CustomerID = 3, Name = "Paul", Phone = "543-7890"] ,  
  
      [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]  
  
}  
  
), each [CustomerID] > 2)  

CustomerIDNamePhone
3Paul543-7890
4Ringo232-1550
Show:
© 2016 Microsoft