cancel
Showing results for
Did you mean:
Helper II

Cumulative sum of a measure

Hello guys. I think this should be an easy one, but I have no ideas..

I have this table where (by day) I have a list of Sales. Also I have a Objective column.. What I need to do is to see the Difference between these two colums (I mean Sales - Obj) and then a new column which shows a cumulative sum of the Difference.. Example:

Day           Obj    Sales      Diff     Diff cumulative

01/01/2018   1200   1330       130             130

02/01/2018   1399   1100      -299           -169

03/01/2018   344     131        -213           -382

04/01/2018   414     2323       1909          1527

05/01/2018   235     414          87              1614

06/01/2018   2535   242        -2293         -679

07/01/2018   2353   412        -1941         -2620

Thanks you all guys!

OC

1 ACCEPTED SOLUTION

Accepted Solutions
Solution Sage

Hi @omarevp

First, create your new column :

`Diff = YourTable[Sales] - YourTable[Obj]`

```Diff cumulative =
CALCULATE (
SUM (YourTable[Diff] ),
ALL ( YourTabke),
YourTable[Day] <= EARLIER (yourTable[Day])
)```

Have a good day

- Quentin

4 REPLIES 4
Solution Sage

Hi @omarevp

First, create your new column :

`Diff = YourTable[Sales] - YourTable[Obj]`

```Diff cumulative =
CALCULATE (
SUM (YourTable[Diff] ),
ALL ( YourTabke),
YourTable[Day] <= EARLIER (yourTable[Day])
)```

Have a good day

- Quentin

Helper II

Hello @quentin_vigne the thing is, SUM function doesnt allow a measure as an argument.

Helper II

@quentin_vigneand thanks a lot! Have any idea?

greetings 😄

Solution Sage

@omarevp

Your first column should not be a measure but a calculated column. You want the Diff for each row

Create your difference as a calculated column and it should work

- Quentin

Announcements

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors