cancel
Showing results for
Did you mean:
New Member

## Substracting two values in same column

Hi all,

Does anyone know how I can substract two values from one another in DAX? I've tried various ways stated online, but to no succes unfortunately. Below a pic of the very simple table. I would like to do the following: Total 2 (2350) - Total 1 (1900) = 450.

1 ACCEPTED SOLUTION
Solution Sage

Hi @Amraoui ,

You can create this measure:

Substract =
var Total1 = CALCULATE(SUM('Table'[Total]),'Table'[Index]=1)
var Total2 = CALCULATE(SUM('Table'[Total]),'Table'[Index]=2)
Return
Total2-Total1

If I answered your question, please mark it as a solution to help other members find it more quickly.
2 REPLIES 2
New Member

Respect! Thanks a lot 🙂

Solution Sage

Hi @Amraoui ,

You can create this measure:

Substract =
var Total1 = CALCULATE(SUM('Table'[Total]),'Table'[Index]=1)
var Total2 = CALCULATE(SUM('Table'[Total]),'Table'[Index]=2)
Return
Total2-Total1

If I answered your question, please mark it as a solution to help other members find it more quickly.

Announcements

#### Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

#### European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

#### Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors