Sorted list items
Returns a new list consisting of the items in sorted order, either ascending (default) or descending.
Sample usage
SORT(LookupTable[ColumnC])
returns a sorted list of values from ColumnC
in the LookupTable
Syntax
SORT(list, [descending?])
list
- A list of any type.descending?
- AYes/No
expression. Set toTRUE
to sort in descending order (high to low) orFALSE
to sort in ascending order (low to high). Defaults toFALSE
.