Forum Discussion

ChumaAmako's avatar
ChumaAmako
Helper 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 Cal...
Need Help
  • chethan's avatar
    chethan
    8 years ago

    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

chethan's avatar
chethan
Resolver III
8 years ago

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