Forum Discussion

Mema's avatar
Mema
Frequent Visitor
6 years ago

Greatest difference

I have a table that has 3 columns that make up a unique identifier, I have combined these in a new column. I have been able to do the difference for each one of these for each period in the financial...
Need Help
Tutorial Requests
dax's avatar
dax
Community Support
6 years ago

Hi Mema,

If you want to rank based on ManageCode, you could try to use below calculated column

OutturnDif Rank1 =
RANKX (
    FILTER (
        CombinedData,
        CombinedData[ManageCodeKey] = EARLIER ( CombinedData[ManageCodeKey] )
    ),
    CombinedData[Outturn Dif],
    ,
    ASC,
    DENSE
)

Best Regards,
Zoe Zhi

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

 

 

Mema's avatar
Mema
Frequent Visitor
6 years ago

 you for your response, I get the error EARLIER/EARLIEST refers to an earlier row context which doesn't exist

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi Mema,

    Above expression is used on calculated column, not in measure.

    Best Regards,
    Zoe Zhi

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

     

    • Mema's avatar
      Mema
      Frequent Visitor
      6 years ago

      I have tried it as a column and I get 

      A Single value for column 'ManageCodeKey' in the table 'CombinedData' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result