Monthly Cohort Analysis

[Anonymous]

Hello everyone,

I was able to create the table below on Excel. It is failry simple, I started with a table with Customer ID and Order Month. I then unpivoted the Order Month Column and used CountIfs to calculate the amount of Customers that bought in two different months.

I was asked to replicate this in Power BI, but the amount of data will be substantially bigger and will updated several times a day, meaning that unpivoting the dates and having to manualy add them to a matrix will not be an option.

I have already checked various Cohorts tutorials, but they always focus on a cumulative Cohort (which means that they only look at the date of entry of a Customer and his Last), which will not be the case here.

Has anyone dealt with this challenge before?

Any help would be much appreciated 🙂 

[v-janeyg-msft]

Hi, @Anonymous 

It’s my pleasure to answer for you.

According to your description,I can't see where are your Customer IDs, How did you deal with it?

Can you share some sample data in Power BI and your desired result?So we can help you soon.

Best Regards

Janey Guo