Monthly Cohort Analysis

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 🙂