Arranges members of a set, optionally preserving or breaking the hierarchy.

Syntax

 Order(Set_Expression, Value)
 Order(Set_Expression, Value, Symbol)

Arguments

Set_Expression
MDX expression that returns set.
Value
Value by which this set should be ordered
Symbol

ASC, DESC - orders ascending or descending within members hierarchy

BASC, BDESC - orders ascending or descending overriding members hierarchy

Examples

The following example would get all the invoices for the selected customer, would sort them by Invoice date, return the last invoice and show it's date.

Order(
Filter(
NonEmptyCrossJoin(
[Invoice].[Invoice].members,
[Customer].CurrentMember
),
NOT IsEmpty([Measures].[Invoice base amount])
),
[Invoice].CurrentMember.get('Invoice date'),
DESC
).Item(0).Item(0).get('Invoice date')