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

Yemeng_Hu's avatar
Yemeng_Hu
Frequent Visitor
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