How to use what if scenario in running total measure

[dglawson]

Hi there,

I'm having some trouble getting this chart to work.

I have a bunch of dates (beginning of month)

2018-07-01

2018-08-01

2018-09-01

2018-10-01

2018-11-01

2018-12-01

I want to be able to make projects based on some numbers

a starting value (savings)

1st what if parameter (income)

2nd what if parameter (expenses)

Basically, I want to start with the starting value (savings).

And then for each month, add the income (what if parameter), and take away expenses (what if parameter)

For those that are more visual, ive included an example of what I'm trying to do below. 

Has anyone got any ideas on how to make this work?

[v-yuta-msft]

Hi dglawson,

"And then for each month, add the income (what if parameter), and take away expenses (what if parameter)"

<---- Could you clarify more details about your requirement and post measures you are using?

Regards,

Jimmy Tao

[dglawson]

I've tried using a running total quick measure, with the sum of the value being subtracted from the initial figure, though this does not pass through the dates.