Forum Discussion
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...
Where does the denominator come from?
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
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.
I don't see anyway to attach a file to provide you the raw data.
Just provide an example using the table feature in the post reply