Cumulative sum of measures

[giorgi_lommidd]

Hi all, 
Can you tell me how to calculate cummulative sum (CumulatieSumOfMeasure1And2) of differance between measure1 and measure2 ? While measure1 and measure2 are calculated from other table's column using calculate method

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[giorgi_lommidd]

Here is the link of row data : https://drive.google.com/file/d/1BGRTRJwvlvlSOp5LGZGS7RifNLNqtfqt/view 
I need to have CUMULATIVE sum of BalanceForcast mesure in table ForcastedBalane, not just sum  

[v-lili6-msft]

hi, @giorgi_lommidd 

Please re-upload the file, This link requires permissions.

and if this formula could meet your requirement?

Cumulative sum of measures = CALCULATE([Measure1]+[Measure2],FILTER(ALL(TestTable),TestTable[Date]<=MAX(TestTable[Date])))

By the way, the TestTable should create a relationship with ForcastedBalane by date column.

If not your case, please share the expected output based on your sample data.

Best Regards,

Lin