Create a measure based on the most recent supplier qoh + next week forecast production - baseline

[Volvo_Chang]

Hello Power BI community,

So my data is as below:

I like to take the most recent supplier invneoty QOH on weekending index 52 which is my most recent inventory position + next week forecasted production - next week baseline. Note, there is no value of supplier inventory QOH past weekending index 52 but row 53 will be based on the calculation above. row 54 will be based on the new value of the row 53 supplier inventory qoh + row 54 forecast production - row 54 baseline and so for.

Thanks!

[v-jianpeng-msft]

Hi, @Volvo_Chang 

In Power BI, I don't currently have the impression that multiple columns are supported for iterative calculations with results.

Your next QOH value depends on the calculated value of the previous row, and also depends on the bank's forecast value as well as the benchmark value. This is difficult to do in Power BI's calculate engine.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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