Forum Discussion

tally's avatar
tally
Regular Visitor
4 years ago

Weekly Cohort

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 week012
August 6th, 2022100%73%49%
August 13th, 2022100%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:)

Need Help

2 Replies

  • danextian's avatar
    danextian
    Super User
    4 years ago

    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.

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    3 years ago

    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