cancel
Showing results for
Did you mean:
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

Announcements

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors