Cohort visual creation help.

[ROG]

Hi all,

I need to create an acquisition month on month churn trend as the one below, but I'm struggling to do it in Power BI.
The examples from here don't apply to my case.

Using a matrix, how can I have a No of Customers by Month Year comparing to lost of customers by Month Year?

Thank you

[amitchandak]

@ROG , if you looking at the lost customer%, then you can not have a customer in visual .

Your two dates will be the first customer date and the current customer .

In this blog, I created a bucket in the first date, instead of that join that with another date table and use month year from there. Two date tables are needed in this case

https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-3-Period-Of-Stay-Cohort-Anal...