Hi
I’ve created a cohort analysis table for a monthly subscription model. Clicking the slicer buttons will show retained, churned, average sales etc.
I now want to get the average of the populated cells for each month into the subscription and then create a bar chart.
For example, for Retained % I want to end up with a table like the below. Average is adding all the populated cells for that month and then dividing by the number of populated cells.
Once I have the table my intention is then to create a bar chart (the example below is just a rough approximation done in Excel.)
My working file is attached.
Any thoughts on how the averages for each month could be calculated would be much appreciated.
Thanks
Cohort sample.pbix (1001.4 KB)