cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

DAX for Cumulative subtraction

I have two columns 

 

ValueTotal
10600
20600
40600
30600
10600
80600
20600
40

600

 

Expected output is

 

Output
590
570
530
500
490
410
390
350

 

Please suggest a DAX formula to perform this action.

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
CheenuSing Super Contributor
Super Contributor

Re: DAX for Cumulative subtraction

Hi @aktripathi2506

 

1. From your table display choose Edit Query

2. When the Query Editor Opens up choose AddColumn tab and Index Column from 0

3. Create RunTot columns as

    RunTot = CALCULATE(sum(Table1[Value]), FIlter(Table1,Table1[Index]<=EARLIER(Table1[Index])))

    ( replace Table1 by the name of your table )

4. Create another column Final 

    Final = [Total]-[RunTot]

5. Plot the values in a Table Chart and you will get the desired output.

  

Capture.GIF 

 

If this works for you please accept this as a solution and also give KUDOS.

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

View solution in original post

1 REPLY 1
CheenuSing Super Contributor
Super Contributor

Re: DAX for Cumulative subtraction

Hi @aktripathi2506

 

1. From your table display choose Edit Query

2. When the Query Editor Opens up choose AddColumn tab and Index Column from 0

3. Create RunTot columns as

    RunTot = CALCULATE(sum(Table1[Value]), FIlter(Table1,Table1[Index]<=EARLIER(Table1[Index])))

    ( replace Table1 by the name of your table )

4. Create another column Final 

    Final = [Total]-[RunTot]

5. Plot the values in a Table Chart and you will get the desired output.

  

Capture.GIF 

 

If this works for you please accept this as a solution and also give KUDOS.

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 295 members 2,886 guests
Please welcome our newest community members: