DAX calculated column summation by category with values previous and current record

[ProveluNL]

Hello,

I have the following table (goods movements) and want to calculate total qty (current row) by adding current qty to total qty (previous row). Who can help me?

Calculated Column

[ProveluNL · Accepted solution]

I found the answer:
Sum Qty =

VAR CurrArtId = [Art_id]

VAR CurrTr_Id = [Tr_id]

RETURN

CALCULATE(

SUM(Goods_movement[Qty]);

FILTER(ALL(Goods_movement);

AND(Goods_movement[Art_id] = CurrArtId ; Goods_movement[Tr_id] <= CurrTr_Id)

) )

[YJ]

Hi,

might not be the best efficient way but you get what you want:

Cal_Tot_Qty = CALCULATE(SUM(Table1[Qty]),FILTER(Table1,Table1[Tr_id]<EARLIER(Table1[Tr_id])+1))

put this in your cal column.

Our ans differ, check your ID row 4,7 . if i understand correctly, this should be it.

regards

[ProveluNL]

Thanks for your help.

But the counting should start over again when the ART (article id) changes.

Rgrds