Forum Discussion
Anonymous
8 years agoNot applicable
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.
Any ideas on how I can do this?
Anonymous
Try this column
Column = RANKX ( FILTER ( table1, Table1[ID] = EARLIER ( Table1[ID] ) ), Table1[Date], , ASC, DENSE )
5 Replies
- Zubair_Muhammad
Community Champion
Anonymous
Try this column
Column = RANKX ( FILTER ( table1, Table1[ID] = EARLIER ( Table1[ID] ) ), Table1[Date], , ASC, DENSE )- AnonymousNot applicable
That did it. Thanks so much.
- AnonymousNot applicable
Hey I am also trying this but did not work for me
kindly help