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.
Related content
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for