Forum Discussion
Balance Inventory table
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
1 Reply
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.
