Running sum between a Start Date and End Date Column

[ConnorA]

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!!

[sgintowt]

Can u share the file? or can you help with this post? 

https://community.fabric.microsoft.com/t5/Desktop/Start-date-and-end-date-cumulatively-sum/m-p/35912...

[v-shex-msft]

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

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.