Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors