Редагувати

Поділитися через


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.

START AT
EVALUATE
VAR
DEFINE
DAX queries