Forum Discussion
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...
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.
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.