Table.Last
Returns the last row or a specified default value.
function (table
as table, optionaldefault
as nullable any) as nullable any
Returns the last row of the
table
or an optional default value, default
, if the table is empty.Table.Row operations
Find the last row of the table.
Table.Last(Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"], [CustomerID = 2, Name = "Jim", Phone = "987-6543"], [CustomerID = 3, Name = "Paul", Phone = "543-7890"]}))
[CustomerID = 3, Name = "Paul", Phone = "543-7890"]
Find the last row of the table
({})
or return [a = 0, b = 0] if empty.Table.Last(Table.FromRecords({}), [a = 0, b = 0])
[a = 0, b = 0]
Last modified 4yr ago