Weekly Cohort

[tally]

Hello,

I did a monthly cohort analysis in PowerBI and now I'm trying to do the same on a weekly basis.

My data table looks like this:

The 'First SC Month' column is for the monthly cohort.

I already calculated the end of the week, and I would like my table to look like this (for example):

date-end of week	0	1	2
August 6th, 2022	100%	73%	49%
August 13th, 2022	100%	68%

I also have another table with the future weeks, basically it's all values between 0-120

Can you please help me with the measure I need?

Thank you:)

[v-luwang-msft]

Hi @tally ,

Not clear how to get the output result from base data.Could you pls share sample data ,and how to get the output result? Remember to remove confidential data.

Best Regards

Lucien

[danextian]

Hi @tally ,

Please post a sample data that we can easily manipulate/copy-paste, not an image?  Also, how do you calculate those percentages in your expected result? You can post a link to an excel file that has both the raw data and the calculation.