Forum Discussion

alexXelya's avatar
alexXelya
Regular Visitor
8 years ago
Solved

Creating timeline according to join date

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's avatar
    v-yulgu-msft
    8 years ago

    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

2 Replies

  • prateekraina's avatar
    prateekraina
    Memorable Member
    8 years ago

    alexXelya

     

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

     

    Prateek Raina

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    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