Forum Discussion

corrado69's avatar
corrado69
New Member
2 years ago
Solved

cumulative sum

this is a simplified version of my project: - una table with a column date and a colum A: Date A 01-gen 1 01-feb 2 01-mar 3 01-apr 4 01-mag 5 01-giu 6 01-lug 7 01...
  • govindarajan_d's avatar
    2 years ago

    Hi corrado69 ,

     

    Can you try the following formula?

    CumulativeSum = 
    CALCULATE([SumOfAandB],FILTER(ALL(Date), DateTable[Date] <= MAX(DateTable[Date]))