Forum Discussion
Quantifying Total Invoiced Per Month
pls see the attachment below
Hi Ryan,
What I believe the way the current column only takes into account one month behind. So what I would like for the column to look for all entries with the same PO an infinte number of months behind. So for example, with a dataset where I don't have a partial invoice payment for 3 months would still show that the total for that month is 40.
| Purchaser | Purchase Order | Invoiced Amount | Uninvoiced Amount | Date Modified | Spent |
| Jill | 1 | 10 | 90 | 01/01/2024 | 10 |
| Jack | 2 | 0 | 100 | 01/01/2024 | 0 |
| Jill | 1 | 50 | 50 | 01/21/2024 | 50 |
| Jack | 2 | 100 | 0 | 01/21/2024 | 100 |
| Jill | 1 | 60 | 40 | 02/01/2024 | 10 |
| Jill | 1 | 100 | 0 | 05/21/2024 | 40 |
Lastly for the PowerBI visual, I would preferably like a dashboard that can display monthly invoice spend and also show it based on the person as well based on a slicer that allows you to select the person. So the graph would show up like:
If Jill were selected from the slicer it would display this:
And finally if Jack were selected in the slicer it would display:
Thanks!
pls see the attachment below