Forum Discussion
Helper IInventory risk based on expiry dates
I want to calculate my risk for my inventory based on expiry dates for this invnetory and expted sales
Assume today is April 07
for Product A:
April sales = 150 units / 30 days X 23 days remaining = 115 units
inventory lot a1 will be sold
inventory lota2 willsell 65 units ; 435 units remain at the end of april in this lot.
May Sales 150 units
Lot a2 will have 285 untis left at the end of May
This lot expires June 01 the 285 needs to show as risk on June 01
June sales 250 units
Lot a3 will sell - no issues
how do i calculate the running inventory showing at end of april 635 units in inventory
June 01 285 expiry and only 200 unit in inventory ?
similar for product B and C.
Thank you
Hi GGerritsen ,
Thank you for being a part of Microsoft Fabric Community Forum!Thanks so much for sharing all the details. At this point, since we’ve explored a lot of possibilities and the issue seems to go a bit deeper, I think the best next step would be to raise a support ticket with Microsoft. That way, the support team can take a closer look with the right tools and internal access.
To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.
Regards,
Menaka Kota.
