Cumulative total by group

[jlamprecht]

I know how to create a running total column with 

calculate(
sum ( table[Values]),
all(table),
table[date] <= earlier (table[date])
)

however, I have several jobs on one table that need their own running totals. Sample data would be:

Job      Period     Amount    Running Total
Job1    201901    5000         5000
Job1    201902    10000       15000

Job2    201901    3000         3000
Job2    201902    4000         7000

What is the best way to do this? I think I need to do it as a column since on the report page, there is a date filter and the running total needs to go to the beginning of time regardless of the report filter.

Thank you!

[parry2k · Accepted solution]

@jlamprecht try this

calculate(
sum ( table[Values]),
allexcept(table, table[job]),
table[date] <= earlier (table[date])
)

[jlamprecht]

That is working perfectly!