Power Query
Search…
published
Table
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]})
Copy link
On this page
Table.LastN
Description
Category
Examples