bluetaurean
Member
Hello,
I have a table with monthly demand and another table with stocks and their expiry dates. Demand can be satisfied with stocks that have not expired. the output needed is to show the good stocks that are consumed and stocks that expire separately. If demand is more than stock, the consumption will be to extent of goods stocks, after deducting all stocks expired in prior periods. For simplicity, all stocks expire on the last day of the month, and demand is shown on the first day of the month.
I have set an example in excel as attached (output required as per the table named OutputTabhlighted in Green). i am trying to get this output with PowerPivot. Can someone help, please.
I have a table with monthly demand and another table with stocks and their expiry dates. Demand can be satisfied with stocks that have not expired. the output needed is to show the good stocks that are consumed and stocks that expire separately. If demand is more than stock, the consumption will be to extent of goods stocks, after deducting all stocks expired in prior periods. For simplicity, all stocks expire on the last day of the month, and demand is shown on the first day of the month.
I have set an example in excel as attached (output required as per the table named OutputTabhlighted in Green). i am trying to get this output with PowerPivot. Can someone help, please.