Table.LastN
Returns the last specified number of rows.
function (tableas table, optionalcountOrConditionas nullable any) as table
Returns the last row(s) from the table,
table, depending on the value of countOrCondition: Table.Row operations
Find the last two rows of the table.
Table.LastN(Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"], [CustomerID = 2, Name = "Jim", Phone = "987-6543"] , [CustomerID = 3, Name = "Paul", Phone = "543-7890"]}), 2)
Table.FromRecords({[CustomerID=2,Name="Jim",Phone="987-6543"],[CustomerID=3,Name="Paul",Phone="543-7890"]})
Find the last rows where [a] > 0 in the table.
Table.LastN(Table.FromRecords({[a = -1, b = -2], [a = 3, b = 4], [a = 5, b = 6]}), each _ [a] > 0)
Table.FromRecords({[a = 3, b = 4], [a = 5, b = 6]})
Last modified 4yr ago