Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Create a cumulative line chart based on two tables

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.

 

TaskIDStart DateEnd DateResourceIDTotal Cost (From Resource)
11/01/20022/01/20021100
11/01/20021/01/2002210
21/01/2002 5/01/2002 1150

 

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

DateRunning Total
1/01/200230 + 50 + 10 = 90
2/01/200290 + 50 + 30 + 170
3/01/2002170 + 30 = 200
4/01/2002200 + 30 = 230
5/01/2002230 + 30 = 260

 

Thanks!

 

  • 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.

3 Replies

  • 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's avatar
      Anonymous
      Not applicable

      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!