Forum Discussion
ChumaAmako
Helper I
8 years agoRanking 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.
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
Resolver III
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
- Ashish_Mathur
Super User