Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Cumulative or Rolling total issue

I am trying to do a simple cumulative total using the below measure and having trouble.  The cumulative total is not adding up if i try the DATESMTD or DATESYTD functions. What am i missing    cum...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Anonymous 

    Then you have to have an index or ranking column. In other words, for each date-serial combination there must be a unique sort order number column. There a method to do that using dax it is preferable to be done using power query. 

davehus's avatar
davehus
Icon for Memorable Member rankMemorable Member
4 years ago

Hi Anonymous ,

 

Because you have the serial in the table, this is causing the issue with the RT not working for you. Please use the measure below, it should work.

 

 

 

cumulative Total = calculate(sum(Trans[Amount]),ALL(Trans),DATESYTD(Trans[Date]))
 
Use the date column from the trans table in the matrix.
 
Did I help you today? Please accept my solution and hit the Kudos button.
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks davehus . Appreciate the help

     

    That worked. Only issue is if i have the serials for same day, the cumulative totals repeats. How can it be treated as mor as running totals

     

    1400 & 1000 for Jan 20th, results in 3600 repeated for the day