Creating timeline according to join date

[alexXelya]

I want to create a new date column according to the user join date. Meaning I have an user who created a profile anytime in the last 5 years and I want to be able to create a date column that will track the evolution of a user's activity. I want to compare all users first month of activity , second month and so on. If any question has already been answered with the same topic please feel free to redirect me. Thanks in advance for the tips.

[v-yulgu-msft · Accepted solution]

Hi @alexXelya,

Suppose there is a User Account field and a Acticty Date field in table. Please add below calculated columns:

Year_month =
'User Activity'[Date].[Year] * 100
    + 'User Activity'[Date].[MonthNo]

Rank =
RANKX (
    FILTER (
        'User Activity',
        'User Activity'[User] = EARLIER ( 'User Activity'[User] )
    ),
    'User Activity'[Year_month],
    ,
    ASC,
    DENSE
)

Best regards,

Yuliana Gu

[prateekraina]

@alexXelya

Please provide some existing dummy data and data which you expect to better explain your problem.

Prateek Raina