Whats wrong in my DAX?

[azaterol]

Hey all,

here is my calculated column.

accumulated Stock = 
calculate(
sumX('Goods logistics','Goods logistics'[Stock]),
FILTER(All('Goods logistics'),
And('Goods logistics'[Stock ID]=EARLIER('Goods logistics'[Stock ID]),
'Goods logistics'[Date]<=EARLIER('Goods logistics'[Date])
)))

It works fine until I have multiple outputs in a day. As an example, there are three outputs on August 13, 2022. The only correct thing here is the final score of -4. I wrote down the expected subtotals. Where is my misconception?

I calculated the 'stock' column in Power Query with 'Input' minus 'Output'.

Here is the sample:

https://easyupload.io/qy59vb

Thank you for help.

[amitchandak · Accepted solution]

@azaterol , try document number in place of date

accumulated Stock = 
calculate(
sumX('Goods logistics','Goods logistics'[Stock]),
FILTER(All('Goods logistics'),
And('Goods logistics'[Stock ID]=EARLIER('Goods logistics'[Stock ID]),
'Goods logistics'[Document No]<=EARLIER('Goods logistics'[Document No])
)))

[azaterol]

@amitchandak  Doc Nr is fine, works great. With creating an index in power query I get more success! Anyways thank you.

[azaterol]

@amitchandak  

not the expected output...