Cumulative Column By Date Range

[kala2]

I'm trying to make bar chart with a running total of costs for each project for a specific date range. Each project Has a start/end date. By selecting a project on a slicer the chart should be adjusted for the specific date range and should display only the costs for this date period.

I want to achieve something like this:

                           Costs   CostsCumulative

February 17        20       20

March 17            30       50 

April 17               30       80

Minimum reproduction .pbix files can be found on dropbox: 
https://www.dropbox.com/sh/1fyp0hks3p0q4hm/AABNEJBXJconaSA1qv0jtPbHa?dl=0

 

[amitchandak · Accepted solution]

@kala2 , if these two blog on same topic can help

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

the formula in this Matrix as Project plan Visual: https://youtu.be/R25QoiyoSVs

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...