Table.LastN

Table.LastN

Returns the last specified number of rows.

function (table as table, optional countOrCondition as nullable any) as table

Description

Returns the last row(s) from the table, table, depending on the value of countOrCondition:

Category

Table.Row operations

Examples

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]})