Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
Hi,
You may refer to my solution here.
Hope this helps.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |