I am working on supply chain dashboard and I am struggling with how to create a measure that will show the supply days, that is, for how many days my ending stock would be enough to cover my demand for. I need this measure to preferably work on different product hierarchies and market level.
A simple example is that if my monthly demand for feb, mar, apr, may was 20, 10, 10, 20 respectively, and at the end of Jan20 my ending stock for product A was 50 units, that means I have enough stocks to cover me for 105 days.
Any help on this would be highly highly appreciated.
sample.pbix (110.9 KB)