Forum Discussion

ChumaAmako's avatar
ChumaAmako
Icon for Helper I rankHelper I
8 years ago
Solved

Ranking with Filters

Hi  Team,

 

I must confess I am still a newbie to DAX,

 

I have a Table with which I wish to rank Visit Time based on Date and Staff ID. It looks like this:

 

 

I will like to have a Calculated Column that Ranks the Visit Time by Visit Date & StaffNo. Like this:

 

 

What Formula can I use for the calculated column.

 

You can view the above data in excel format here: https://drive.google.com/file/d/0Byxc8IzPhZ5-YUx3MnBlR0FjZ1U/view?usp=sharing

 

Thank you.

 

Ashish_Mathur v-ljerr-msft

  • ChumaAmako

     

    Follow the below steps

     

    Create a New Calculated Column Datasheet

     

     

    DateTime = Table3[Visit Date] &" " &Table3[Visit Time]
    Rank = RANKX(ALL('Table3'),'Table3'[DateTime],,ASC) 

     

     

    Regards,

    Chetan K

2 Replies

  • chethan's avatar
    chethan
    Icon for Resolver III rankResolver III

    ChumaAmako

     

    Follow the below steps

     

    Create a New Calculated Column Datasheet

     

     

    DateTime = Table3[Visit Date] &" " &Table3[Visit Time]
    Rank = RANKX(ALL('Table3'),'Table3'[DateTime],,ASC) 

     

     

    Regards,

    Chetan K