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