Arranges members of a set, optionally preserving or breaking the hierarchy.
Syntax
...
Code Block |
---|
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.
Code Block |
---|
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') |