Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion

    Anonymous

     

    Try this column

     

    Column =
    RANKX (
        FILTER ( table1, Table1[ID] = EARLIER ( Table1[ID] ) ),
        Table1[Date],
        ,
        ASC,
        DENSE
    )
    • Anonymous's avatar
      Anonymous
      Not applicable

      That did it. Thanks so much.

      • Anonymous's avatar
        Anonymous
        Not applicable

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

        kindly help