Forum Discussion

jlamprecht's avatar
jlamprecht
Regular Visitor
7 years ago
Solved

Cumulative total by group

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!

  • jlamprecht try this

     

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

2 Replies

  • jlamprecht try this

     

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