calculate overstock based on stock by expiry date and forecast

[smetdi]

Hello,

I need to calculate the future risk on overstock based on stock by expiry date and forecast volume.

My table looks like this: 

The result should look like this: 

The yellow marked cells are calculated based on stock (marked blue) and forecast volume (marked green).

If on a specific day, the volume of a specific expiry date is not sufficient, the next expiry date volume should cover. 

Any idea how to do the calculation? 

Thanks

[smetdi]

I will simplify my request, this is what I need to create: 

What is the best way to approach this? 

[Ashish_Mathur]

Hi,

Your question is not clear.  Share the download link of the Excel file with the formulas intact so that the logic of the yellow cells can be understood.

[lbendlin]

Looks like you want to refactor your source data into two separate tables. One for the stock and one for the forecast.  Then join the tables via the product in the Power BI data model.