cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## How to create column which is cumulative sum of measure

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.

1 ACCEPTED SOLUTION
Helper V

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
3 REPLIES 3
Helper V

Can you please share a sample data?

Helper I
Helper V

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