Forecast coverage vs stock

[ekoland88]

I need your help

I have some forecast values: Dec:323, Nov:346. October:321 and some stock value 616.

I need a measure that calculates how many months I can cover with the current stock.

The answer on this particular case is 1,87 months.

Please help!

[v-zhenbw-msft]

Hello @ekoland88 ,

What is the structure of your table?

If the table structure is so, you can test the following measure.

Measure = 
var _not_stock_value = CALCULATE(SUM('Table'[values]),FILTER('Table','Table'[forecast]<>"stock"))
var _not_stock_count = CALCULATE(DISTINCTCOUNT('Table'[forecast]),FILTER('Table','Table'[forecast]<>"stock"))
var _stock_value = CALCULATE(SUM('Table'[values]),FILTER('Table','Table'[forecast]="stock"))
return
DIVIDE(
    _stock_value,
    DIVIDE(_not_stock_value,_not_stock_count))

If you don't meet your requirements, could you show the exact expected result based on the table we shared?

Best regards

Community support team _ zhenbw

If this post helps,then consider Accepting it as the solution to help other members find it faster.

BTW, pbix as an attachment.

[amitchandak]

@ekoland88 , there is a post By Greg on this. See if that can help

https://community.powerbi.com/t5/Quick-Measures-Gallery/Days-of-Supply/td-p/635656

or this

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