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

Argument

Description

table

The Table to check.

condition

The 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)



CustomerID

Name

Phone

3

Paul

543-7890

4

Ringo

232-1550

Show:
© 2016 Microsoft