Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Guys,
I'm stuck with a problem and cant get a solution. Your help will be really appreciated.
I have a Inventory table and order and return table. I need to calculate the days when stock becomes 0
Refer to this imag. the first measure is stock which is coming from inventroy table and demand is coming from order and return tables. Now I need to calculate the count of days when this stock becomes 0. the demand will be constant. So the calculation will be (2222-87) on 12th sept then (2135-87) on 13th sept and it will be going like this till it becomes 0. your help will really be appreciated
@Piku , refer if one of these can help
https://blog.enterprisedna.co/calculate-days-of-zero-stock-power-bi-inventory-management-insights/
https://radacad.com/calculating-stock-on-hand-using-dax-power-bi-inventory-model
Hi Amit,
Thank you for replying. I have gone through these and it doesnt solve the problem as it doesnt calculating the running subtraction. And my data is coming from different tables.
@Piku , Can you please share some sample data, so I can try to calculate?
https://drive.google.com/file/d/1bi2xBjgun6FN1sYGDXK0qS_i3a9qqILC/view?usp=sharing
I have uploaded the pbix in this link. Could you please check
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |