ORDER BY
Introduces a statement that defines sort order of query results returned by an EVALUATE statement in a DAX query.
Syntax
[ORDER BY {<expression> [{ASC | DESC}]}[, …]]
Parameters
| Term | Definition |
|---|---|
| expression | Any DAX expression that returns a single scalar value. |
| ASC | (default) Ascending sort order. |
| DESC | Descending sort order. |
Return value
The result of an EVALUATE statement in ascending (ASC) or descending (DESC) order.
Remarks
To learn more about how ORDER BY statements are used, see DAX queries.