cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
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
Solution Sage

Hi @omarevp

 

First, create your new column :

 

Diff = YourTable[Sales] - YourTable[Obj]

Then add a new column 

 

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

Have a good day

 

- Quentin

View solution in original post

4 REPLIES 4
Solution Sage
Solution Sage

Hi @omarevp

 

First, create your new column :

 

Diff = YourTable[Sales] - YourTable[Obj]

Then add a new column 

 

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

Have a good day

 

- Quentin

View solution in original post

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

@quentin_vigneand thanks a lot! Have any idea?

 

greetings 😄

@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

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

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