Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Cohort Analysis Help

I have been struggling to determine how to calculate the denominator values in the attached examples. Getting the Cohort data and Numerators are easy but just cant figure out the denominator to get the right percentages. Any help would be greatly appreciated. In the end I am trying to replicated the percentages matrix. 

 

 

"DAX"

9 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      The denominator is a calculation of a formula 

       

      SUM(OFFSET($D$105,-$D128,0):OFFSET($D$105,-MAX($D129,D$130)-1,0)) = 2023 month 0 cohort value 628

      • AnthonyGenovese's avatar
        AnthonyGenovese
        Resolver III
        3 years ago

        You need to be more clear with what data you have already loaded and what the business logic is. Please provide a table of what you are loading into power BI, the business logic (not excel), and then an example.