cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
Helper IV

Inventory at risk of expiring

Hi, 

 

I need to provide inventory which is at risk of expiring every month from July- Dec.

 

I have the average sales from the last 3 months and inventory expiry dates per product and batch. 

 

How can I go about achieving inventory which is at risk of expiring? 

 

 

4 REPLIES 4
Community Support
Community Support

Hi @Sdhn420 ,

 

What's your expected result, to add a flag to mark the inventory which is at risk?

Please show some sample data and expected result to us.

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

@v-jayw-msft  

I need to find qty of stock due to expire. 

 

https://drive.google.com/file/d/1toYuwNTYtF1rJza6dgzSq54daZHskraf/view?usp=sharing

 

-Each product has different batch. Each batch has different products.

 

- if the average sales for the last 3 months of that product is more than the qty then check if that product is available in other batches and is not expired. If yes, then take qty from that batch.

 

-if we are taking qty from other batch, then display the updated qty

 

-if there is qty left which will not be sold and cant be used - that is what needs to flagged.

Super User I
Super User I

@Sdhn420 

https://community.powerbi.com/t5/Desktop/Inventory-calculation-Based-on-expiry-date/m-p/769510

I hope this thread may help you! Let me know if it resolves your issue!




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Thanks! But doesn't solve my issue. 

I need it to be monthly from Jul-Dec and batch wise for each product.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors