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 t...
"DAX"
Anonymous's avatar
Anonymous
Not applicable
3 years ago

This is an example of  the data that I am using and represents the numerator part of the equation. I am not that familiar with the OFFSET function in Excel and having a nested OFFSET inside an offset is thowing me off on how the denominator is being calculated. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

 

132132132132132132132132132132132
399399399399399399399399399399399
393393393393393393393393393393393
296296296296296296296296296296296
177177177177177177177177177177177
263263263263263263263263263263263
400400400400400400400400400400400
779779779779779779779695624546466
62851739827915478162233311391446
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    This is the expected outcome for the denominator