Forum Discussion

vanSiq01's avatar
vanSiq01
Regular Visitor
3 years ago

Running Total with multiple Measures

Hi!!   I've been struggling to solve this problem for a few days now. I wanted to calculate a moving sum with multiple measures. I've create an Excel example for it: Excel Example     In o...
DAX
power bi
Running Totals
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi vanSiq01 

Please try

Accumulated Value =
SUMX (
FILTER ( 'Table', 'Table'[Index] <= EARLIER ( 'Table'[Index] ) ),
IF ( 'Table'[Operation] = "+", 1, -1 ) * 'Table'[Base Value]
)

vanSiq01's avatar
vanSiq01
Regular Visitor
3 years ago

Hi tamerj1 !

 

Thank you for reply. Your code is a partial solution for this. Note that, I need from Measure1 (Start Value) add/subtract values of Measures 2 (Breakdowns).

 

Your code works for only one measure... but I need to start from one measure and add/subtract with the other one.

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    vanSiq01 
    I followed what you have presented. You have presented everything in a table but you never mentioned whether it is a data table or a table visual. You did not provide any description of your data, rather you just presented a data in an excel sheet! Therefore, I assumed that this is a data table. Based on that, I have proposed my solution. If I have the wrong understanding then please clarify.