Forum Discussion
Ageing Debtor Count
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):
7 Replies
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.
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?
You are welcome. Share some data and clearly show the xpected result on the data that you share.
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.
