How to calculate lost customers

[Anonymous]

Hi, I need to find a way to calculate lost customers, in my case I have a monthly report that is consolidated in power query, if last month and ID existed but this month does not appear it is because he has gone, I just have to count how many of them have gone in a table similar to this one:

PD: I already have a calendar table.

How could I achieve this?

Thanks in advance.

[amitchandak]

@Anonymous , refer to my blog, that can help

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529

[Anonymous]

Hi @amitchandak I followed the blog but it is a little different because in my case I the lastest data I have is the last month and in your example assume that in the current month there is data so that you can compare them, I should compare the last month with his previous.

Any idea? thanks

[v-easonf-msft]

Hi, @Anonymous 

Please check whether the solution in this related thread can be helpful to you.

How-do-I-calculate-Lost-Customer-Sales 

If it doen't work for you ,please share a sample file for testing.

Best Regards,
Community Support Team _ Eason