Happy New Year to Y’all !!!
I’m having a hard time trying to get the right answer and I thought that someone can help me out.
I’m trying to obtain the Date Difference between the Expiration Date and Current Day of all the Subproducts while removing the Subproducts with an Inventory Level of fewer than 0 units.
Here’s the measure I came out with:
Product Life =
VAR InventoryTable =
“Units Inventory”, [Units Inventory],
“Current Date”, TODAY ()
VAR GreaterthanZero =
FILTER ( InventoryTable, [Units Inventory] > 0 ) //Inventory of Subproducts greater than Zero
DATEDIFF ( TODAY (), MAX ( Subproducts[Expiration Date] ), MONTH )
I get a value but every time I added the measure with the Subproduct ID I get an error.
I need to get these values in a Measure, not in a Calculated Column though.
Thanks for the help!!!