Hi Everyone,
This is Budy from Indonesia.
I want to do a recursive calculation in Power Pivot. The calculation is very simple actually, if I do in excel sheet, it'd take less than a minute to finish that, but I wanna do that in Power Pivot.
I've read on below link can do a recursive calculation:
Recursive Calculations in PowerPivot using DAX | Gerhard Brueckl's BI Blog
But on that link only convert a recursive calculation into a mathematical logic. But however the idea is very brilliant,haha..
Well, this is my table data:
<tbody>
</tbody>
My goal is D column, can you help me?
Thanks,
Budy.
This is Budy from Indonesia.
I want to do a recursive calculation in Power Pivot. The calculation is very simple actually, if I do in excel sheet, it'd take less than a minute to finish that, but I wanna do that in Power Pivot.
I've read on below link can do a recursive calculation:
Recursive Calculations in PowerPivot using DAX | Gerhard Brueckl's BI Blog
But on that link only convert a recursive calculation into a mathematical logic. But however the idea is very brilliant,haha..
Well, this is my table data:
R\C | A | B | C | D | Formula for D Column |
0 | 0 | 0 | B - A = 0 | 0 | 0 |
1 | 100 | 200 | B - A = 100 | 100 | =IF(D0+C1<0,0,D0+C1) |
2 | 70 | 0 | B - A = -70 | 30 | =IF(D1+C2<0,0,D1+C2) |
3 | 100 | 0 | B - A = -100 | 0 | =IF(D2+C3<0,0,D2+C3) |
4 | 100 | 300 | B - A = 200 | 200 | =IF(D3+C4<0,0,D3+C4) |
<tbody>
</tbody>
My goal is D column, can you help me?
Thanks,
Budy.