topic Re: DAX command for continuous sum bassed on each row in DAX Commands and Tips

DAX command for continuous sum bassed on each row

markuslegeler — Thu, 04 Apr 2024 10:30:44 GMT

Dear community,
I already tried several possibilities to sum up row by row based on the following table:

quantity in kg Pt/Ru	unit (kg)	type	sorting	Index	actual stock	expected values
66,902103	kg	local stock	45386	0	if local stock = using the number of column quantity in kg Pt/Ru	66,902103
50	kg	order	45836	1	if order deduct column quantity in kg Pt/Ru from previous row of actual stock	16,902103
25	kg	order	45863	2	if order deduct column quantity in kg Pt/Ru from previous row of actual stock	-8,097897
25	kg	order	45863	3	if order deduct column quantity in kg Pt/Ru from previous row of actual stock	-33,097897
32,5	kg	production order	45887	4	if production order add column quantity in kg Pt/Ru from previous row of actual stock	-0,597897
32,5	kg	production order	45901	5	if production order add column quantity in kg Pt/Ru from previous row of actual stock	31,902103

But no proposed formula delivered the expected values.

Is anybody able to help.

Thanks in advance.

Re: DAX command for continuous sum bassed on each row

lbendlin — Thu, 04 Apr 2024 18:06:17 GMT

Here is one example

Re: DAX command for continuous sum bassed on each row

markuslegeler — Fri, 05 Apr 2024 04:42:42 GMT

Sorry to ask a stupid question, did you put in the DAX directly in the visual or in the table as new column?
Do I need to replace Table with the name of my existing table?

Re: DAX command for continuous sum bassed on each row

ThxAlot — Fri, 05 Apr 2024 18:43:58 GMT

Actual = CALCULATE( CALCULATE( SUM( STK[Quantity in kg Pt/Ru] ), STK[Type] IN { "local stock", "production order" } ) - CALCULATE( SUM( STK[Quantity in kg Pt/Ru] ), STK[Type] = "order" ), STK[Index] <= EARLIER( STK[Index] ), REMOVEFILTERS() )