How to create column which is cumulative sum of measure

[giorgi_lommidd]

Hi all, 

I have table with 'date' and 'col2'  columns. In this table I also have 'measure1' and 'measure2'. 
In this table I need to create  COLUMN ('col3') , that will be cumulative sum of 'measure1' and   'measure2'. 
Hope this info would be enough.  

[mohittimpus]

Can you please share a sample data?

[giorgi_lommidd]

https://drive.google.com/open?id=1Y6trAenqdS07xgcEe-OuRgWv2vxdDnX5

[mohittimpus · Accepted solution]

Hii@giorgi_lommidd,

Create two measures:

Measure = [measure1]+[measure2]

Cumulative Total measure =

IF(MIN(Sheet1[date])<=CALCULATE(MAX(Sheet1[date]),ALL(Sheet1)),CALCULATE([Measure],FILTER(All(Sheet1[date]),Sheet1[date]<=MAX(Sheet1[date]))))

you can add only Cumulative Total Measure to the table view.

If this helps, mark it as Accept as Solutions,

Thanks,

mohittimpus