Forum Discussion
Running sum between a Start Date and End Date Column
Hey all,
I am having an issue which I cannot seem to find a solution for. Its frustrating me because I believe the solution will be quite simple.
I want to create a bar graph that shows the rolling sum of a value between a start date and end date.
For example:
| Value | Start date | end date |
| 5 | 2021/04/10 | 2021/04/15 |
| 2 | 2021/04/10 | 2021/04/17 |
| 10 | 2021/04/15 | 2021/04/20 |
Now I want this to be in a bar graph (that shows every day, I created a Date Dimensions table to have every day of the year) but I want the rolling sum. Most bar graphs are only letting me use either the start date or end date as axis and therefore doesnt consider the rolling sum. For example: On 2021/04/15 the sum would actually be 17 because all 3 dates overlap on that date. The following day would be 12.
I cant seem to think of an elegant way to do this, I even tried to see if there were any widgets that can address this. This is something I could do easily in excel but it must be in powerBI.
Any ideas would be tremendously appreciated!!
3 Replies
- Ashish_Mathur
Super User
- AnonymousNot applicable
HI ConnorA,
I'd like to suggest you take a look at the following link to create a expanded table for start date, end date analysis requirements:
Solved: Spread revenue across period based on start and en... - Microsoft Power BI Community
Regards,
Xiaoxin Sheng
- sgintowt
Helper I
Can u share the file? or can you help with this post?