Forum Discussion
How to split the values into each months between the start date and end date
It still is unclear how you came up with 346.90 but try the attached pbix.
Super UserhI Azco_Data
How did you come up with unbilled usage for row in the second image. From Feb-25 to Mar-4 2025, there are only 8 days. 1040.69/8 * 3 = 390.26
Super UserIt still is unclear how you came up with 346.90 but try the attached pbix.
Thanks. I am new to this community so I am not being able to attach the pbix file. But here the task is to split the usage and dollars for each month between the start date and end date. As I described in the other replies, the usage and dollars are divided by the number of active days in each month between start date and end date
- danextian
Hi Azco_Data
Between Feb 25 and Mar 4, there are 8 days Feb 25 included so the daily rate would be 130.08 x 3 and that would be 390. Now if Feb 25 were to be excluded, there are only 7 days so the daily rate would be 148.67 x 3 = 446.01. Neither of these numbers match the unbilled usage for Feb in your expected result. This is what we need clarification from.
Also, please have a look at the attached pbix in my previous response. It is a bit advanced but if you want the calculations dynamic then that's the way to go.
