Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Sum First logins

Hi All,   I'm trying to calculate the number of first logins by date. Here's a simplified version of my dataset:   User ID     Login Date 123           01/01/18 123           02/01/18 123     ...
Need Help
  • Yemeng_Hu's avatar
    Yemeng_Hu
    8 years ago

    Hi Chris, 

     

    Here you go:

     

    First_logIn_Date = Calculate(
                                       Min(Login Date), 
                                       AllExcept (PA, PA[User ID])
                                       )

    New_Customer_count = Calculate( DistinctCount(PA[Customer ID], 
                                                             Filter( PA,
                                                             PA[Login_Date] = PA[First_login_Date]))

    First_login_Date is a calculated column, and New_customer_count is a measure. 

     

    Thanks,

    Yemeng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks Yuliana. Does the first login need to be a specific format? It's not allowing me to add  PA[First Login date] to the formula. When I try adding to a table, it only shows one date. It's only when I add userID to the tabel that i get the full list of first login dates.

 

Thanks,

Chris

 

 

 

 

 

 

 

 

 

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

Hi Anonymous,

 

PA[First Login date] has to be a calculated column rather than a measure.

 

Regards,

Yuliana Gu