cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shanipowerbi Helper II
Helper II

Previous period (not month) active users

I was working on cohort analyses and created periods for retention analyses. The period column in datasheet was calculated through the Invoice date.
 
Now I need to calculate churn rate % for this I need the previous period (not month) active users.
Capture2.JPG

 

Data attached for your reference
 
4 REPLIES 4
Super User IV
Super User IV

Re: Previous period (not month) active users

Hi @shanipowerbi ,

Try this: Added a column just not sure that I got the churn formula correct.

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

 

 

Churn = Var PrevpV =CALCULATE(SUM(Churn[Active Users ]),Filter(All(Churn),Churn[Period]=EARLIER(Churn[Period])-1))
 Var Presentper = Churn[Active Users ]

 var Dif = Presentper-PrevpV

       return Divide (dif,PrevpV)

Churn1.PNG

 

 

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




shanipowerbi Helper II
Helper II

Re: Previous period (not month) active users

Thanks for the feedback, our formula is

Current - Prevous / Previous

So, in Our cas for Exmple : Period 1 is our Current  and 0 is Previous.

Super User IV
Super User IV

Re: Previous period (not month) active users

@shanipowerbi ,

Which is what I am showing. (Current - Previous)/Previous

 

var Dif = Presentper-PrevpV

       return Divide (dif,PrevpV)

 If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




shanipowerbi Helper II
Helper II

Re: Previous period (not month) active users

@Nathaniel_C , I really appreciate your time and effort you put in. Please understand some of my previous calculations.

1 - I have a table name Active Users Data (Contain Invoice Date, Conversion Date, User ID's)

2 - I have calculated Measure total active users by using "Total Active Users = DISTINCTCOUNT('Active Users Data'[user_ids])"

3 - I have calculated Column Period by using "Period = DATEDIFF('Active Users Data'[User with Conversion Data.ConversionDate],'Active Users Data'[created_at],MONTH)".

4 - I have got this Table. Conversion Date / Active Users / Period, which tell me the customer retention.

5 - I have made the cohort Table the help of above table.

 

Point - 5.JPG

6 - For Calculating Churn in Need Period Month Users, that's what i looking for.

 

Please help you can. Hope I explained well this time

 

Regards

 

Zeeshan

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.