Forum Discussion

shanipowerbi's avatar
shanipowerbi
Helper III
6 years ago

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.

 

Data attached for your reference
 
churn
previous

4 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    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)

     

     

     

     

    • shanipowerbi's avatar
      shanipowerbi
      Helper III
      6 years ago

      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.

      • Nathaniel_C's avatar
        Nathaniel_C
        Community Champion
        6 years ago

        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