Forum Discussion
Projecting Inventory to Expire based on forecast
Hi everyone! Posting this question for my inventory tracking project. Summary: I would like to build a tracker/dashboard to track my inventory expiration risks based on forecasted usage. In...
First, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Second, I think you are looking for something along the lines of Days of Supply:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Days-of-Supply/m-p/635656#M318
Hi Greg_Deckler ,
I'm valuating the opposite which is excess supply.
I'm stuck with the problem considering that:
1. Different batches and different expiration dates per material,
2. I need to factor in First to Expire, First to Use concept.
A straightforward calculation of Total Usage - Inventory will not work for the project. 😞