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 r...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    jlamprecht try this

     

    calculate(
sum ( table[Values]),
allexcept(table, table[job]),
table[date] <= earlier (table[date])
)
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

jlamprecht try this

 

calculate(
sum ( table[Values]),
allexcept(table, table[job]),
table[date] <= earlier (table[date])
)
jlamprecht's avatar
jlamprecht
Regular Visitor
7 years ago

That is working perfectly!