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
Icon for Community Champion rankCommunity Champion
7 years ago

Hi Anonymous,

You can add a column and the code below.

Rank Meter by End Date = 
VAR m = Table1[Meter]
RETURN 
RANKX(
    FILTER(
        Table1,
        Table1[Meter] = m
    ), 
   Table1[End Date],,
   ASC
)


Regards,
Mariusz

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