Forum Discussion

Maram's avatar
Maram
Frequent Visitor
9 years ago
Solved

Cumulative Total

Hello.  I am trying to create a cumulative total for each month but I am getting data per month which I don't want to have. I used this measure   Cumulative = CALCULATE( SUM(Finance[Column CC]), ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Filtering all Finance Table (not only a column), I get the Cumulative for the month, but if you have duplicate dates, the cumulative will be the same, in both.

     

    Cumulative = CALCULATE(
    		SUM(Finance[Column CC])
    		,FILTER(ALL(Finance), Finance[Date] <= MAX (Finance[Date])))

     

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

I use the same formula, and works.

 

Can you take a print? or sample data? The Financial[Date] have 1 date per month?

More details can help.