Avoiding Circular Dependency when Calculating Inventory Projection

Hi stellion17 ,

DAX cannot reference the data in the previous row, i.e., DAX cannot implement iteration.

But based on the information you provided, perhaps you can modify your formula to:
Month 1 Figure = InitialInventory + SumInboundPOsMonth1 - ForecastMonth1
Month 2 Figure = InitialInventor + ( SumInboundPOsMonth1 + SumInboundPOMonth2 ) - ( ForecastMonth1 + ForecastMonth2 )
Month 3 Figure = InitialInventor + ( SumInboundPOsMonth1 + SumInboundPOMonth2 + SumInboundPOMonth3 ) - ( ForecastMonth1 + ForecastMonth2 + ForecastMonth3 )
...............
As long as all the data in your SumInboundPOsMonth and ForecastMonth columns are present.

Or you can use List.Accumulate or List.Generate in Power Query, two M functions that enable iteration.

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