Running Total by date based on value in another column

[NI]

I want a running total by date for the Amount Column which should be different for each Security ID.

[Zubair_Muhammad · Accepted solution]

Hi @NI

First add an Index Column from Query Editor or Power Query

[Zubair_Muhammad · Accepted solution]

Hi @NI

First add an Index Column from Query Editor or Power Query

[Zubair_Muhammad · Accepted solution]

@NI

Now you can get the expected Cumulative  Values using this Calculated Column

Cumulative =
CALCULATE (
    SUM ( TableName[Amount] ),
    FILTER (
        ALLEXCEPT ( TableName, TableName[Security ID] ),
        TableName[Index] <= EARLIER ( TableName[Index] )
    )
)

[eranatatera]

hi @Zubair_Muhammad 

I have a follow up qustion about your amazing explanation, 

let's assume I have another "Country" column at the table, which I want to take as a paramater while calculating the running total, so that the cumulative total column will show not only cumulative total over time by securtiy Id but also by country, like in the example below- how should I revise the calculation in order to do so? 

Thanks ! 

[Zubair_Muhammad]

@NI

See the attached file here