Cumulative forecast and cumulative cost over time on same graph

[TimPowerBI]

Hi there,

Is it possible to have a cumulative forecast line (of cost) on the same graph as cumulative cost. What I am looking for is for the cumulative cost line to go from start date to 'today' (today just being whatever date the actuals stop and forecasting starts) and then the forecast line carry on from 'today' to the end date in seperate colours.

My data is in weekly costs. So I have a cumulative measure for the actuals and a cumulative forecast measure however this starts at 0 so I have added the sum of costs which gives the black line below. 

Currently I have two lines however the cumulative cost just stays flat after 'today' and the forecast line is flat until 'today'. Please see image

(Sorry removed axis labels etc. Green = actuals, black = forecast)

Is this possible?

Thanks in advance!

[lbendlin]

add a condition to your two measures that returns blank when the value would equal today's value.

[parry2k]

@TimPowerBI yes it is possible, assuming already have measures

Actual New = CALCULATE ( [Actual Measure], DateTable[Date] <= TODAY() )

Forecast New = CALCULATE ( [Forecast Measure], DateTable[Date] >= TODAY() )

drop these new measure in the line visual and will get you the result and two different colors as well.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[TimPowerBI]

Sorry I didnt specify how my data is a layed out. I have edited my post to reflect this.

The forecast data I have is in weekly costs. So my cumulative forecast measure starts at zero. This means I also need to add the total of the actuals as well to the forecast data.

[parry2k]

@TimPowerBI did you tried the solution already posted?

[TimPowerBI]

@parry2k I have yes, it gave me the right forecast graph however starting from 0 not the sum of the actuals.

What I am essentially looking for now is a way to add a scalar onto this to shift the entire graph up by the sum of the actuals. I cant seem to do this without setting the base before 'today' causing the black graph or just adding 0 because I filtered out the actuals. 

[parry2k]

@TimPowerBI there are many ways to do it, can you share how you data looks like and what measures you have created so far, please paste the sample data in table format and also paste dax expressions.