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

     

     

Maram's avatar
Maram
Frequent Visitor
9 years ago

tringuyenminh92

 

Aha thank you. It turns out I need to get Date from different table, my measure now look like this :

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

 

I only have the actual data from April to Sept, and budget data from April to March.  The graph is showing actual data from April to March, even though I don't have the actual data for actual from Sept to March. Is there a way to show zero or no actual data from Oct to March?


   

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