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])))

     

     

tringuyenminh92's avatar
tringuyenminh92
Memorable Member
9 years ago

Hi Maram,

 

I'm sorry but i could not understand your description, could you please explain again? And if you take a look my picture, there is no actual data in July so it's empty. That's default with no configuration.

Maram's avatar
Maram
Frequent Visitor
9 years ago

Hi tringuyenminh92

 

Your data samples were helpful.  The measure is working.

 

Thank you for your help :)