cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shanipowerbi Frequent Visitor
Frequent Visitor

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
Highlighted
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 Frequent Visitor
Frequent Visitor

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 Frequent Visitor
Frequent Visitor

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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors