SORT()

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? - A Yes/No expression. Set to TRUE to sort in descending order (high to low) or FALSE to sort in ascending order (low to high). Defaults to FALSE.

See also

List expressions

List functions

ANY()

INDEX()

LIST()

MAX()

MIN()

ORDERBY()

TOP()

UNIQUE()

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
18277681813853888410
true
Search Help Center
true
true
true
false
false