Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago
Solved

Classify User Recurrence

Hello dear community. Tengo la siguiente tabla en un csv, è incluso ya la tengo cargada en el Power BI. +----------+----------+-----+ | fecha • msisdn • MAU • +----------+----------+-----+ | 1-J...
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    Hi, Syndicate_Admin 

     

    You can try the following methods.

    Column:

    Count = CALCULATE(COUNT('Table'[msisdn]),
            FILTER('Table',[fecha]>=DATE(2023,3,1)
                            &&[fecha]<=DATE(2023,7,1)
                            &&[msisdn]=EARLIER('Table'[msisdn])))
    Recurrence type = SWITCH(TRUE(),
[Count]=5,"Recurring",
[Count]=4||[Count]=3,"casual",
[Count]<3,"new")

    Measure:

    From = MINX(FILTER('Table',[Recurrence type]=SELECTEDVALUE('Table'[Recurrence type])),[Count])
    To = Var _Max=MAXX(FILTER('Table',[Recurrence type]=SELECTEDVALUE('Table'[Recurrence type])),[Count])
Return
IF([From]=_Max,BLANK(),_Max)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.