Forum Discussion
DAX: Ranking in dataset based on datetime column in same dataset
Hi community,
I have a team members dataset about users that are part of a particular team and the created at of the user is given as a datetime column.
I am trying to make a custom column in DAX to give a rank to the users based on their "user_created_at" datetime in order to get an overview as to which user is the n-th person in that team.
The dataset looks like:
| team_id | user_id | user_created_at |
| 1 | a | 28 sept 2022 11:30 |
| 1 | b | 28 sept 2022 10:00 |
| 1 | c | 28 sept 2022 12:00 |
| 2 | d | 28 sept 2022 11:00 |
| 2 | e | 28 sept 2022 10:00 |
I want the following outcome:
| team_id | user_id | user_created_at | rank |
| 1 | a | 28 sept 2022 11:30 | 2 |
| 1 | b | 28 sept 2022 10:00 | 1 |
| 1 | c | 28 sept 2022 12:00 | 3 |
| 2 | d | 28 sept 2022 11:00 | 2 |
| 2 | e | 28 sept 2022 10:00 | 1 |
I think that I have to use RANKX() in order to obtain the answer I want. I believe that this is not a difficult question, but I couldn't figure it out DAX-wise. If anyone could maybe provide the proper DAX code would be amazing.
Thank you for your time!
