Table.AlternateRows

Table.AlternateRows
Keeps the initial offset then alternates taking and skipping the following rows.
function (table as table, offset as number, skip as number, take as number) as table
Description
Keeps the initial offset then alternates taking and skipping the following rows.     
Category
Table.Row operations
Examples
Return a table from the table that, starting at the first row, skips 1 value and then keeps 1 value.
Table.AlternateRows(Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"], [CustomerID = 2, Name = "Jim", Phone = "987-6543"], [CustomerID = 3, Name = "Paul", Phone = "543-7890"]}), 1, 1, 1)
Table.FromRecords({[CustomerID=1,Name="Bob",Phone="123-4567"],[CustomerID=3,Name="Paul",Phone="543-7890"]})

Table.AggregateTableColumn

Table.Buffer

Last modified 4yr ago