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:
<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
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
Last edited: