DAX based on previous calculation

[pociners]

Hello everybody,

I want to calculate the future stock based on the incoming stock and forecast sales.
The data and calculation for the future stock is very simple actually, but i don't know how to manage it via power pivot or DAX, can you help me? please..

This is the data:

Column	Data	W0	W1	W2	W3	W4	W5	W6
A1	Forecast		100	100	100	150	100	100
A2	Incoming Stock		200	0	200	30	0	300
A3	Future Stock	0	100	0	100	0	0	200
A4	Future Stock Formula	0	=IF( A3(W0)+A2(W1)-A1(W1)<0 ,0 ,A3(W0)+A2(W1)-A1(W1))	=IF( A3(W1)+A2(W2)-A1(W2)<0 ,0 ,A3(W1)+A2(W2)-A1(W2))	=IF( A3(W2)+A2(W3)-A1(W3)<0 ,0 ,A3(W2)+A2(W3)-A1(W3))

<tbody>
</tbody>

The A3 column is the result from A4 column. I assume that A3(W0) is zero.
Well, the formula for Future Stock is like looping from the previous. Can powerpivot manage this? or do you have any idea to solve this case?

If you have any question about my case, please feel free to ask.

Thanks,
Budy

 

[pociners]

Good morning all..