cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
relsharif Regular Visitor
Regular Visitor

Rank based on date for each individual user

Hello all,

 

I am trying to write a measure or column (whichever one does the trick) that ranks the due date for each individual in the table based on his or her respective due dates. For example, I have this table below. Whenever I try to rank their due dates I get an overall rank (see rank column) . What I am looking for is what's in the rankx column. A rank of due date for each customer only. Rankx example.PNG

 

Any ideas on how I can do this?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Rank based on date for each individual user

@relsharif

 

Try this column

 

Column =
RANKX (
    FILTER ( table1, Table1[ID] = EARLIER ( Table1[ID] ) ),
    Table1[Date],
    ,
    ASC,
    DENSE
)
2 REPLIES 2
Super User
Super User

Re: Rank based on date for each individual user

@relsharif

 

Try this column

 

Column =
RANKX (
    FILTER ( table1, Table1[ID] = EARLIER ( Table1[ID] ) ),
    Table1[Date],
    ,
    ASC,
    DENSE
)
Highlighted
relsharif Regular Visitor
Regular Visitor

Re: Rank based on date for each individual user

That did it. Thanks so much.