How Calculate Days of 0 Stock

[Piku]

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

[amitchandak]

@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

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=991d7143-...

[Piku]

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. 

[amitchandak]

@Piku , Can you please share some sample data, so I can try to calculate?

[Piku]

https://drive.google.com/file/d/1bi2xBjgun6FN1sYGDXK0qS_i3a9qqILC/view?usp=sharing

I have uploaded the pbix in this link. Could you please check