Conditional Recursive Calculation [NEED HELP]

[pociners]

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:

[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]R\C[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]Formula for D Column[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]B - A = 0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]100[/TD]
[TD]200[/TD]
[TD]B - A = 100[/TD]
[TD]100[/TD]
[TD]=IF(D0+C1<0,0,D0+C1)[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]70[/TD]
[TD]0[/TD]
[TD]B - A = -70[/TD]
[TD]30[/TD]
[TD]=IF(D1+C2<0,0,D1+C2)[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]100[/TD]
[TD]0[/TD]
[TD]B - A = -100[/TD]
[TD]0[/TD]
[TD]=IF(D2+C3<0,0,D2+C3)[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]100[/TD]
[TD]300[/TD]
[TD]B - A = 200[/TD]
[TD]200[/TD]
[TD]=IF(D3+C4<0,0,D3+C4)[/TD]
[/TR]
</tbody>[/TABLE]

My goal is D column, can you help me?

Thanks,

Budy.

 

[Ozeroth]

No problem. The key thing is the logic of the formula so if you can make it work for your table setup that's great!

 

[pociners]

No problem. The key thing is the logic of the formula so if you can make it work for your table setup that's great!

I'm still amazed with your logic actually, you are insane sir!!
In Bahasa Indonesia I'd say that you're "Gokil Abis",haha

Thanks!!!