Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Max Rank

Hi

 

I have the following table

 

MeterNoValueRankMax Rank
123101 
123202 
123303MAX
456101 
456202 
456303MAX
    
Table1   

 

Can someone advise me on the formula to return the column Max Rank.

Ideally, I'd like the word MAX to idenify the highest 'Rank' for each 'MeterNo'.

Can you help?

 

Many thanks in advance!

 

Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi Anonymous 

    Try this for your calculated column:

    MaxRank =
IF (
    Table1[Rank] = CALCULATE ( MAX ( Table1[Rank] ), ALLEXCEPT ( Table1, Table1[MeterNo] ) ),
    "MAX"
)

     

     

2 Replies

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Hi Anonymous 

    Try this for your calculated column:

    MaxRank =
IF (
    Table1[Rank] = CALCULATE ( MAX ( Table1[Rank] ), ALLEXCEPT ( Table1, Table1[MeterNo] ) ),
    "MAX"
)