Forum Discussion
Distributing values between start and end date
Hi,
Share some data to work with and show the expected result. Share data in a format that can be pasted in an MS Excel file. Please also explain the question.
I have the below (copied) as 'PaidData' table, with a further -[DatePAY] calendarauto() date table- using the Measure mentioned above within PowerBI. Using the graphs, stacked or lined, for 2024 the total value being reported is £0, and for 2025 £1500. The graph utilises the X and Y axis with just a
For 2024 the actual sum would be £1000 overall. But using the Measure it seems to have disregarded one of the 3 and can't tell what needs tweaked in the Measure. As I can only see £0 for 2024 this visually charts an untrue gap, versus what has been paid for 2024. So am trying to work out how the Measure can be improved, SUMX(SUMMARIZE -the filter would have the same ID but I don't know why its not totalling correctly. Thank you
'PaidData'
| ID | From | To | Amount | Paid |
| 10012 | 01/01/2024 | 31/12/2024 | 1000 | 20/12/2023 |
| 10012 | 01/01/2024 | 31/12/2024 | -1000 | 03/01/2024 |
| 10012 | 01/01/2024 | 31/12/2024 | 1000 | 05/01/2024 |
| 10012 | 01/01/2025 | 31/12/2025 | 1500 | 19/12/2024 |
Hi,
Please refer to my solution of a similar problem in the attached file.