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.

Mariusz's avatar
Mariusz
Community Champion
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.

PMF99's avatar
PMF99
Regular Visitor
7 years ago

Perfect! Thats the answer! 

 

I've ticked the thumbs up box.

 

Is there another 'Accept' button?