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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors