cancel
Showing results for
Did you mean:
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.

4 REPLIES 4
Highlighted
Super User IV

## Re: Previous period (not month) active users

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)```

Proud to be a Super User!

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

## Re: Previous period (not month) active users

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

Proud to be a Super User!

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.

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

Regards

Zeeshan

Announcements

#### 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?

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

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

Top Solution Authors
Top Kudoed Authors