Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
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.
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!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |