Balance Inventory table

[William_Moreno]

Hi everyone,
I need help with this table below, I want to reproduce this in data columns and only with dax formulas, I can't use powerquery in this case. 

Local	PartNumber	Date	Demand	Orders	Transfer	Strategy Invetory	OpenStock	Needed	Revised Need	CloseStock
Italy	303972	01/03/2021	0	8.000	0	9.420	0	-1.420	1.420	9.420
Italy	303972	01/04/2021	10.481	8.000	0	9.420	9.420	-2.481	2.481	9.420
Italy	303972	01/05/2021	11.126	12.000	0	9.420	9.420	0	0	10.294
Italy	303972	01/06/2021	11.490	0	0	9.420	10.294	-10.616	10.616	9.420
Italy	303972	01/07/2021	11.445	0	0	9.420	9.420	-11.445	11.445	9.420
Italy	303972	01/08/2021	11.704	0	0	9.420	9.420	-11.704	11.704	9.420
Italy	303972	01/09/2021	11.970	0	0	9.420	9.420	-11.970	11.970	9.420
Italy	303972	01/10/2021	12.126	0	0	9.420	9.420	-12.126	12.126	9.420
Italy	303972	01/11/2021	11.281	0	0	9.420	9.420	-11.281	11.281	9.420
Italy	303972	01/12/2021	11.381	0	0	9.420	9.420	-11.381	11.381	9.420

The red collors are formulas like theses:

OpenStock = CloseStock month before

Needed = IF(OpenStock + Orders – Demand-Transfer>Strategy,0,OpenStock + Orders – Demand-Transfer-Strategy)

Revised Need = Needed x (-1)
CloseStock = OpenStock + Orders – Demand-Transfer +Needed

I will be very grateful if anyone can help me

thanks in advanced

[Icey]

Hi @William_Moreno ,

I'm afraid this is unachievable with DAX.

This row's value of Measure/Column 1 is based on previous row's value of Measure/Column 2, and This row's value of Measure/Column 2 is based on previous row's value of Measure/Column 2. This kind of calculation logic cannot be implemented with DAX.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.