Forum Discussion

markuslegeler's avatar
markuslegeler
New Member
2 years ago
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 6...
  • ThxAlot's avatar
    ThxAlot
    2 years ago
    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()
)

markuslegeler's avatar
markuslegeler
New Member
2 years ago

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?