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

Hi tringuyenminh92  Thanks for the reply :) I am new to DAX so how would you use it?  I did separate the table into actual and budget before, but it doesnt really work out in the long term as I want to use the same data to create new graphs.  PS its she :P

 

Anonymous Everything is in one table. It would be great if you could find a solution! If there is anything you need, do let me know. I appreciate it :)

tringuyenminh92's avatar
tringuyenminh92
Memorable Member
9 years ago

For DAX, i'm new too ^_^ just write down what i want to do and then searching related functions article & topics.
Maram Back to your question about actual & budget, could you please show the current sample data of actual and budget in picture/file?

And your expectation in file/picture, so I could figure out the solution.