Forum Discussion
Forecasting in Dax
Hello All I wanted to create a Rate Of Sale (ROS) , Week of Sales (WOS) that is in how many weeks the inventory stock will remain and to calculate the run out date The data I have Expecte...
Greg_Deckler
I wanted to show when the stock will become emtpy in weeks, days, and months, as well as the date.
For example
the expect the output should be like
| Product | stock gets empty (in weeks) | stock gets empty (in days) | stock gets empty (in date) |
| A | 13 | 4 | 03/14/2023 |
| B | 14 | 11 | 04/01/2023 |
emma_3 See if this helps: Days of Supply - Microsoft Power BI Community