Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Rank

  Hi,   I have a table, Table1, and I want to rank multiple meters by End date in the following format.   Can you help?   Meter              End Date     Rank 1000364810   2008 06        1 1...
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi PMF99 

     

    please see the below

    =VAR m = Resign_Append[meter]
RETURN
RANKX(
FILTER(Resign_Append,
Resign_Append[meter] = m
),
Resign_Append[CED YYYY MM],,
ASC
)

    Regards,
    Mariusz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

AlB's avatar
AlB
Community Champion
7 years ago

Hi Anonymous,

If 'End Date' is of type date, you can simply do:

Rank_Column =
RANKX ( CALCULATETABLE(Table1, ALLEXCEPT(Table1, Table1[Meter])), Table1[End Date], Table1[End Date], ASC )