Hi there,
I have a huge database of Inventory Management having More than one stores as well as products,
everyday stock is updating by some value(UpdateQty) and having one min value(MinQty)
I calculate values like - Out-of-Stock, Under-Stock, In-Stock using calculation (UpdateQty and MinQty),
Finally, I create a calculated column as StockCheck, which shows the status of every product.
Now I have to show all details in Matrix Chart(Row- Product, Column-Dates, Values-StockCheck),
but it shows blank values if stock is not updated on that date.
So my problem is that I have to calculate the last value on that blank values,
Stores/Dates 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Store3/A Out In under
Store3/B under In
Store4/A In Under Out
Store4/B In
Store5/A Out In
I use the following Measure but it now shows the correct value:
Fillvalue1 =
var _currdate = MAX(ItemInventoryHistory[LastUpdated])
var _lastValue = CALCULATE(LASTNONBLANK(ItemInventoryHistory[LastUpdated],ItemInventoryHistory[LastUpdated]), FILTER(ALL(ItemInventoryHistory),ItemInventoryHistory[LastUpdated] <= MAX(ItemInventoryHistory[LastUpdated])))
return
IF(MAX(ItemInventoryHistory[Stock Check])=BLANK(),_lastValue,MAX(ItemInventoryHistory[Stock Check]))
Plz, Help.
