Table.RemoveLastN
Returns a table with the last N rows removed.
function (tableas table, optionalcountOrConditionas nullable any) as table
Returns a table that does not contain the last
countOrCondition rows of the table table. The number of rows removed depends on the optional parameter countOrCondition. Table.Row operations
Remove the last row of the table.
Table.RemoveLastN(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"]}), 1)
Table.FromRecords({[CustomerID=1,Name="Bob",Phone="123-4567"],[CustomerID=2,Name="Jim",Phone="987-6543"],[CustomerID=3,Name="Paul",Phone="543-7890"]})
Remove the last rows where [CustomerID] > 2 of the table.
Table.RemoveLastN(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)
Table.FromRecords({[CustomerID=1,Name="Bob",Phone="123-4567"]})
Last modified 4yr ago