Measure for -Forward Stock Cover days

[Joshi_M]

Hi,

I have been struggling to create a measure for calculation for Future stock coverage days.Below is a example of Matrix visual in Power BI.

Measure already created for Opening Stock,Demand , Receipts &  Closing Stock .

Opening stock = 

SUMX(

FILTER(ALLEXCEPT(ZBE_12WEEK_DEMAND_AP,ZBE_12WEEK_DEMAND_AP[Plant Text],ZBE_12WEEK_DEMAND_AP[Material Group Family],ZBE_12WEEK_DEMAND_AP[Material]),ZBE_12WEEK_DEMAND_AP[Index weeks]>=0 && ZBE_12WEEK_DEMAND_AP[Index weeks]<=MAX(ZBE_12WEEK_DEMAND_AP[Index weeks])-1),

[Act Stock])

Constraints as below

1. Some slicers are already selected
2. Year and week in text format
3. Field available in Direct query in date format is (First day of the week)
4. Fiels available for index weeks which is filtered for avlues between 0 &11

I want to use a measure to calculate the stock cover days  based on future demand

Kindly help  in creating a measure for Stock cover Days .

Example - Stock cover days for week 2021.06 = 14 ( closing stock = 20 , Demand =20 happens next 2 weeks hence 14)

Year /week	2021.06	2021.07	2021.08	2021.09	2021.1	2021.11	2021.12	2021.13	2021.14
Material
Material A
Opening Stock		20	20	20	20	20	20	20	20
Demand	40	0	20	30	0	10	40	0	30
Receipts		20		20	20	20
Closing Stock	20	40	20	10	30	40	0	0	-30
Stock Cover Days	14.0	11.7	4.7	14.0	10.5

Kindly respond Let me know if anything else is required.

Regards

Joshi M

[Joshi_M]

@amitchandak  Many Thanks for the Links.

I think the belw link will work
 https://community.powerbi.com/t5/Desktop/Days-of-supply/td-p/635223

However Not sure how to apply in my example.

kindly check my example and let me Know
Regards

Manish

[amitchandak]

@Joshi_M , refer if the similar solution of the blog can help

https://community.powerbi.com/t5/Desktop/Number-of-Days-stock-on-hand/m-p/466896

https://community.powerbi.com/t5/Desktop/Days-of-supply/td-p/635223

https://radacad.com/calculating-stock-on-hand-using-dax-power-bi-inventory-model

https://www.pbiusergroup.com/communities/community-home/digestviewer

https://blog.enterprisedna.co/calculate-days-of-zero-stock-power-bi-inventory-management-insights//v...