Table of contents
TOC
Collapse the table of content
Expand the table of content

Table.ReverseRows

Owen Duncan|Last Updated: 5/22/2018

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

CustomerIDNamePhone
4Ringo232-1550
3Paul543-7890
2Jim987-6543
1Bob123-4567
© 2018 Microsoft