Solved: Subtraction of 2 measures in a new Column

haymanezzeldin · ‎03-08-2017

I have 2 measures that are added as columns to the table

How can I subtract these 2 measures? Intellisense doesn't show measures in the DAX formula editor, but shows the real columns.

Please advise,

Best regards,

Hayman

haymanezzeldin · ‎03-08-2017

Add the first measure as a varliable VAR1, and the second one as another variable VAR2, and a third Variable VAR3 as VAR1 - VAR2.

Then use the RETURN function to resturn VAR3

haymanezzeldin · ‎03-08-2017

Add the first measure as a varliable VAR1, and the second one as another variable VAR2, and a third Variable VAR3 as VAR1 - VAR2.

Then use the RETURN function to resturn VAR3

Subtraction of 2 measures in a new Column