Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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. 😞

     

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      6 years ago

      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.

       

      Best Regards,
      Kelly
      Did I answer your question? Mark my post as a solution!