Forum Discussion
Solved
DAX command for continuous sum bassed on each row
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.
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() )
3 Replies
- ThxAlot
Super User
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() ) - lbendlin
Here is one example
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?
