Returns the one-based rank of a specified tuple in a specified set.
Syntax
Rank(Tuple_Expression, Set_Expression [ ,Numeric Expression ] )
Arguments
| Tuple_Expression | A valid Multidimensional Expressions (MDX) expression that returns a tuple. |
|---|---|
| Set_Expression | A valid Multidimensional Expressions (MDX) expression that returns a set. |
| Numeric_Expression | A valid numeric expression that is typically a Multidimensional Expressions (MDX) expression of cell coordinates that return a number. |
Examples
Rank(
[Time].CurrentHierarchyMember, Filter(
[Time].CurrentHierarchyMember.Level.Members, DateBetween(
[Time].CurrentHierarchyMember.StartDate, '24 months ago','today'
) ))