Table.Skip

 

This topic applies to the Power Query Formula Language 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 that does not contain the first row or rows of the table.

Table.Skip(table as table, optional countOrCondition as any) as table  

ArgumentDescription
tableThe Table to modify.
optional countOrConditionThe number of rows to skip.
  • Table.Skip is similar to List.Skip but requires a table as input.

  • If countOrCondition is a number, that many rows (starting at the top) will be skipped.

  • If countOrCondition is a condition, the rows that meet the condition will be skipped until a row does not meet the condition.

Table.Skip(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"]  
  
}  
  
), 2)  

CustomerIDNamePhone
3Paul543-7890
4Ringo232-1550
Show: