Rank values of one column based on Date

[tjlundquist1]

Trying to find a solution to rank people based on the date they were added to a Line#

Below, you can see the Line # column is the same for this example and there are 4 people attached to this Line#. In the 'Date Assinged to Role' column identifies when they were added to this Line#. 

I am wanting to add a column to rank the 'Adjuster' column 1-X based on the 'Date Assinged to Role' column all linking to the 'Line #' column. 1 being the earliest date. There are 10's of 1,000's of Line #'s. Want to be able to see by Line #, who was on it and what order were they added.

Here's the desired result

Thanks!

[Ashish_Mathur]

Hi,

Try this calculated column formula:

=calculate(countrows(data),filter(data,data[line #]=earlier(data[line #])&&data[date assigned o role]<=earlier(data[date assigned o role])))

Hope this helps.

[tackytechtom · Accepted solution]

Hi @tjlundquist1 ,

I got to this solution here:

This is the DAX code I used:

Order added to Role = 
RANKX ( 
    FILTER ( 
        Table29, 
        Table29[Line #] = EARLIER ( Table29[Line #] )
    ),
    Table29[Date assigned to Role],
    ,ASC
    ,Dense
)

Does this get you closer to a solution? 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/