Forum Discussion

y3wan's avatar
y3wan
Frequent Visitor
4 years ago
Solved

Cumulative total

Anyone know why the forumula didnt generate a cummulative total instead? I was expecting 12, 18 & 48.      
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I think it is because SUM('Sheet1'[Cost]) on the first row is already 48. Please try the below calculated column.

     

    ColumnCC =
SUMX (
    FILTER ( Sheet1, Sheet1[Date] <= EARLIER ( Sheet1[Date] ) ),
    Sheet1[Cost]
)
Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

I think it is because SUM('Sheet1'[Cost]) on the first row is already 48. Please try the below calculated column.

 

ColumnCC =
SUMX (
    FILTER ( Sheet1, Sheet1[Date] <= EARLIER ( Sheet1[Date] ) ),
    Sheet1[Cost]
)
y3wan's avatar
y3wan
Frequent Visitor
4 years ago

It works beautifully. Thank you