Forum Discussion
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.
Hi Anonymous ,
You can create this measure:
Substract =var Total1 = CALCULATE(SUM('Table'[Total]),'Table'[Index]=1)var Total2 = CALCULATE(SUM('Table'[Total]),'Table'[Index]=2)ReturnTotal2-Total1If I answered your question, please mark it as a solution to help other members find it more quickly.
2 Replies
Hi Anonymous ,
You can create this measure:
Substract =var Total1 = CALCULATE(SUM('Table'[Total]),'Table'[Index]=1)var Total2 = CALCULATE(SUM('Table'[Total]),'Table'[Index]=2)ReturnTotal2-Total1If I answered your question, please mark it as a solution to help other members find it more quickly.