Show the budget decreasing over time

[octygen]

Hello All! I have the following chart. I am trying to show that there was a budget at the beginning of the graph ($3M) and I want to show how it decreases over time. The goal would be to create a line that starts at $3M and goes down every month as budget is being taken away by the various labor and OE activities.

How can I create a measure to plot such a line?

Note that the activities are aggregations of line items divided by weeks. That is the only raw data I have in my data source. 

[octygen]

THAT helped a lot! Thank you! 

[TomMartens]

Thanks for sharing a screenshot of the result.

I really like the name of the measure 😉

Cheers

Tom

[TomMartens · Accepted solution]

Hey,

w/o having more information about the exact structure of exisiting tables I would create a measure that deducts the running total of all the OE and labor activities, something like this

Measure = 
  3000000 - 
  CALCULATE(
  SUM('table'[labor1]) + SUM('table'[labor2]) + ... + SUM('table'[OEn])
  ,FILTER(
    ALL('table'[datecolumn])
    ,'table'[datecolumn] <= MAX('table'[datecolumn])
  )
)

This site describes alomost everything one has to know to create Date related DAX calculations:

http://www.daxpatterns.com/time-patterns/

Hope this helps

Regards

Tom