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

• START AT
• EVALUATE
• VAR
• DEFINE
• DAX queries