Forum Discussion
calculating duration inventory falls below a specified value
This is my first post, so apologies if I don't have all the information needed.
I'm trying to calculate the start time, end time, duration of time, and count of occurances of when a product's inventory falles below a specified value.
Ultimately I'd like to then find the average sales and margin of the period when the product was effectively out of stock and determine my lost opportunity.
I'm open to all questions; fire away!
2 Replies
- amitchandak
Super User
idymkowski ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
what's the easiest way to share an excel table on here?
