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

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
Nathaniel_C
Super User
Super User

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!




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.

@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!




@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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors