Table.Sort
Sorts the table using one or more column names and comparison criteria.
function (tableas table, optionalcomparisonCriteriaas nullable any) as table
Sorts the
table using the list of one or more column names and optional comparisonCriteria in the form { { col1, comparisonCriteria }, {col2} }.Table.Ordering
Sort the table on column "OrderID".
Table.Sort(Table.FromRecords({[OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0], [OrderID = 2, CustomerID = 1, Item = "1 lb. worms", Price = 5.0], [OrderID = 3, CustomerID = 2, Item = "Fishing net", Price = 25.0], [OrderID = 4, CustomerID = 3, Item = "Fish tazer", Price = 200.0], [OrderID = 5, CustomerID = 3, Item = "Bandaids", Price = 2.0], [OrderID = 6, CustomerID = 1, Item = "Tackle box", Price = 20.0], [OrderID = 7, CustomerID = 5, Item = "Bait", Price = 3.25], [OrderID = 8, CustomerID = 5, Item = "Fishing Rod", Price = 100.0], [OrderID = 9, CustomerID = 6, Item = "Bait", Price = 3.25]}), {"OrderID"})
Table.FromRecords({[OrderID=1,CustomerID=1,Item="Fishing rod",Price=100],[OrderID=2,CustomerID=1,Item="1 lb. worms",Price=5],[OrderID=3,CustomerID=2,Item="Fishing net",Price=25],[OrderID=4,CustomerID=3,Item="Fish tazer",Price=200],[OrderID=5,CustomerID=3,Item="Bandaids",Price=2],[OrderID=6,CustomerID=1,Item="Tackle box",Price=20],[OrderID=7,CustomerID=5,Item="Bait",Price=3.25],[OrderID=8,CustomerID=5,Item="Fishing Rod",Price=100],[OrderID=9,CustomerID=6,Item="Bait",Price=3.25]})
Sort the table on column "OrderID" in descending order.
Table.Sort(Table.FromRecords({[OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0], [OrderID = 2, CustomerID = 1, Item = "1 lb. worms", Price = 5.0], [OrderID = 3, CustomerID = 2, Item = "Fishing net", Price = 25.0], [OrderID = 4, CustomerID = 3, Item = "Fish tazer", Price = 200.0], [OrderID = 5, CustomerID = 3, Item = "Bandaids", Price = 2.0], [OrderID = 6, CustomerID = 1, Item = "Tackle box", Price = 20.0], [OrderID = 7, CustomerID = 5, Item = "Bait", Price = 3.25], [OrderID = 8, CustomerID = 5, Item = "Fishing Rod", Price = 100.0], [OrderID = 9, CustomerID = 6, Item = "Bait", Price = 3.25]}), {"OrderID", Order.Descending})
Table.FromRecords({[OrderID=9,CustomerID=6,Item="Bait",Price=3.25],[OrderID=8,CustomerID=5,Item="Fishing Rod",Price=100],[OrderID=7,CustomerID=5,Item="Bait",Price=3.25],[OrderID=6,CustomerID=1,Item="Tackle box",Price=20],[OrderID=5,CustomerID=3,Item="Bandaids",Price=2],[OrderID=4,CustomerID=3,Item="Fish tazer",Price=200],[OrderID=3,CustomerID=2,Item="Fishing net",Price=25],[OrderID=2,CustomerID=1,Item="1 lb. worms",Price=5],[OrderID=1,CustomerID=1,Item="Fishing rod",Price=100]})
Sort the table on column "CustomerID" then "OrderID", with "CustomerID" being in ascending order.
Table.Sort(Table.FromRecords({[OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0], [OrderID = 2, CustomerID = 1, Item = "1 lb. worms", Price = 5.0], [OrderID = 3, CustomerID = 2, Item = "Fishing net", Price = 25.0], [OrderID = 4, CustomerID = 3, Item = "Fish tazer", Price = 200.0], [OrderID = 5, CustomerID = 3, Item = "Bandaids", Price = 2.0], [OrderID = 6, CustomerID = 1, Item = "Tackle box", Price = 20.0], [OrderID = 7, CustomerID = 5, Item = "Bait", Price = 3.25], [OrderID = 8, CustomerID = 5, Item = "Fishing Rod", Price = 100.0], [OrderID = 9, CustomerID = 6, Item = "Bait", Price = 3.25]}), { {"CustomerID", Order.Ascending}, "OrderID"})
Table.FromRecords({[OrderID=1,CustomerID=1,Item="Fishing rod",Price=100],[OrderID=2,CustomerID=1,Item="1 lb. worms",Price=5],[OrderID=6,CustomerID=1,Item="Tackle box",Price=20],[OrderID=3,CustomerID=2,Item="Fishing net",Price=25],[OrderID=4,CustomerID=3,Item="Fish tazer",Price=200],[OrderID=5,CustomerID=3,Item="Bandaids",Price=2],[OrderID=7,CustomerID=5,Item="Bait",Price=3.25],[OrderID=8,CustomerID=5,Item="Fishing Rod",Price=100],[OrderID=9,CustomerID=6,Item="Bait",Price=3.25]})
Last modified 4yr ago