DAX: Ranking in dataset based on datetime column in same dataset

[Anonymous]

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!

[achanikya]

[CNENFRNL · Accepted solution]

[Anonymous]

Perfect, thanks a lot!