Ageing Debtor Count

[Selwynster]

Hi all

I am trying to count the number of distinct debtors who have an invoice date > 12 months ago, from today.
This needs to be rolling figure on a bar chart

Source data could look something like:

Debtor No	Invoice Date	Item No
1	2022/03/01	2
1	2022/02/20	3
2	2022/12/24	1
3	2021/04/21	1

End visual hoping for something like (just a guide):

[v-rongtiep-msft]

Hi @Selwynster ,

What is your desired output? Could you please provide you pbix file without privacy information and desired output with more details?

How to Get Your Question Answered Quickly 

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

In this PBI file, i have tried to derive at the debtors per month with the condition that you have specified.  Plug in your actual data and see if for each month you get the correct figure or not.  Once you are OK with that result, then we will get the running total.

[Selwynster]

Thank you so much @Ashish_Mathur , but the results dont seem correct. Seems maybe its only summing for the month and not for all periods going back? 

[Ashish_Mathur]

You are welcome.  Share some data and clearly show the xpected result on the data that you share.

[Selwynster]

https://1drv.ms/u/s!AhNtTaweU4MzmDzD6JFUAXy0sqfk?e=cXfzOy
Please see above link. I should be getting 1076 (as seen by total on the right table) for July on the left graph; 
And 691 for June. 

[Ashish_Mathur]

That is a dead link.

[Selwynster]

Will do.
Just a quick note on your end result table...the date should be August 2022 (today's month)