Forum Discussion
Projecting Inventory to Expire based on forecast
Hi Anonymous ，
Could you show us your .pbix file or sample data if there's nothing confidential?You can upload it to onedrive and share us with the link.
Kelly
Hi v-kelly-msft ,
Here's the sample file for your reference
https://1drv.ms/x/s!Al4XUPsgrRwrzEfkjaedUIEPpWql?e=7m8TsP
Thanks!
JCPO
Hi Anonymous ，
So for "status":
IF('Table'[date]>'Table'[Expiration date]&&'Table'[On hand Inventory]>0,"overstock",BLANK())
What date should I use to compare with 'expiration date'?Today()?
For"Inventory stock",how should I get the result?
Your sample data is really a bit complex,better show me a clear logic.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!hi, since Anonymous ist not active I will try to put some logic.
Expiration date should pe a parameter until when the goods can be used.
In case that FC qty. until the expiration day is lower than stock on hand, you will end up with excessive stock that has to be evaluated. In this case from the day of expiration you need to switch to the next exp. date batch of the same product if existing and continue to supply according to the forecast.
In the opposite case where FC qty. ist higher than qty. expirarion day simply switch to next batch if available when stock ist utilised.
Hope it helps. br Mila
Anonymous thank you so much for your response.
Your logic makes sense. The next challenging part is how will the dax be around this logic?
