Hi,

I have the following problem. My matrix countains products, currentstock at time, and current price at the time.

As you can see, this product started with 40 stock, and gets lower with sales. It works great. But if i add a date filter, and lets say i give it 2022.06.17 as starting date it starts counting from 0. The correct starting stock should be 37. I dont have the current stock quantity in tables, i have to calculate it from sales and delivery records.

I tried this measure but its not working.

VAR varDate = SELECTEDVALUE(BI_DocumentItemsView[BI_DocumentHeadersView.FulfillmentDate_Local_Date])

VAR minDate =

Calculate(

MIN(BI_DocumentItemsView[BI_DocumentHeadersView.FulfillmentDate_Local_Date]),

All(BI_DocumentItemsView)

)

VAR varProduct = SELECTEDVALUE(BI_DocumentItemsView[ProductId])

RETURN

CALCULATE(

SUM(BI_DocumentItemsView[ItemQuantityDir]),

BI_DocumentItemsView[BI_DocumentHeadersView.FulfillmentDate_Local_Date] <= varDate

&& BI_DocumentItemsView[BI_DocumentHeadersView.FulfillmentDate_Local_Date] >= minDate

&& BI_DocumentItemsView[ProductId] = varProduct,

FILTER(Movements,Movements[Stock]= TRUE())

)

Also if i close the product the row total aint working.

The expected result would be the last stock quantity at the time. Starting from 40 to 28, if i close the row it should show 28 as the current stock.

I would like to ask for same help how to fix this problem.

Thank you.

Forum Discussion

Count quantity per month

Inventory and Stock balance calculation

stock ageing

Counting nulls

stock ageing