Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |