Rank based on date for each individual user

[Anonymous]

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. 

Any ideas on how I can do this?

[Zubair_Muhammad · Accepted solution]

@Anonymous

Try this column

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

[Anonymous]

That did it. Thanks so much.

[Anonymous]

Hey I am also trying this but did not work for me

kindly help

[Anonymous]

It is showing below erro message

"EARLIER/EARLIEST refers to an earlier row context which doesn't exist."

[NishantAgarwal7]

You can't use it in a measure, create a calculated column.