Create a cumulative line chart based on two tables

[Anonymous]

Hi there,

Very new to PowerBI tools, currently a bit stuck on this issue. 

I have two tables

• Tasks table with a Proposals (another table) foreign key
  • Has two notable columns: Start Date and End Date
• Resources Table
  • A resource with a total cost

I've joined the two tables based on a TaskID and the Resource table that has a foreign key linked to Tasks, so the structure is similar to this, with other columns as well.

TaskID	Start Date	End Date	ResourceID	Total Cost (From Resource)
1	1/01/2002	2/01/2002	1	100
1	1/01/2002	1/01/2002	2	10
2	1/01/2002	5/01/2002	1	150

There may be multiple tasks involved in a proposal, is there a way to do a running cumulative line chart where it may increase on a per day basis so it can produce something like this below?

Running total costs

Date	Running Total
1/01/2002	30 + 50 + 10 = 90
2/01/2002	90 + 50 + 30 + 170
3/01/2002	170 + 30 = 200
4/01/2002	200 + 30 = 230
5/01/2002	230 + 30 = 260

Thanks!

[Ashish_Mathur · Accepted solution]

Hi,

I have assumed that you want to accumulate from January 1 of each year.  You may download my PBI file from here.

Hope this helps.

[Anonymous]

Hi @Ashish_Mathur ,

Thanks for your help! I've tried to download the file, but it appears to be a dead link. Could you please take a look.

Regarding the task start dates, they can be any arbitrary time but I should be able to figure it out.

Thanks again!

[Ashish_Mathur]

Hi,

You are welcome.  The link works just fine.  Retry.