New, recurring and closed customers

[Anonymous]

Hi,

I am doing a creditor report, where I need to analyze creditors on a monthly basis. Each month, I add month-end data per creditor which is then analyzed in the report.

I would like to be able to compare the creditor churn and show the number of recurring, new and closed creditors. The churn should be between two optional months as well as the latest month and the earliest month. Also, I need to be able to make a list filtered by the different kinds of creditors (new, recurring, old)

I have attached a creditorlist as well as the report I'm currently building in onedrive:

Onedrive dummy file 

Any advise or info is much appreciated!

Thank you for your time 

[Greg_Deckler]

@Anonymous See if this helps: https://community.powerbi.com/t5/Quick-Measures-Gallery/New-and-Returning-Customers/m-p/168297#M13