Table.ReverseRows

Syntax

Table.ReverseRows(table as table) as table

About

Returns a table with the rows from the input table in reverse order.

Example 1

Reverse the rows in the table.

Table.ReverseRows(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"]}))
CustomerID Name Phone
4 Ringo 232-1550
3 Paul 543-7890
2 Jim 987-6543
1 Bob 123-4567