Negative to Positive or Positive to Negative

[AkshayManke]

Hi,

I want to change the amount value from positive to negative or negative to positive based on a condition as below.

Reference Data

Code	Amount
A1	100
B2	-80
C3	110

Condition = If the Code is starting with A or B then change the Amount as (If '- then +' or If '+ then -' ). New Value will be captured in a different column.

So the outcome would be captured as below.

Code	Value	New Value
A1	100	-100 (Became Negative from Positive)
B2	-80	80 (Became Positive from Negative)
C3	110	110

Can anyone please help that how to achieve this?

Regards,

[PaulDBrown · Accepted solution]

@AkshayManke 

If you want to add a new column:

Change sign (c) = 
VAR _Code = LEFT(Table1[Code], 1)
RETURN
SWITCH(TRUE(),
_Code = "A", Table1[Amount] * -1,
_Code = "B", Table1[Amount] * -1,
Table1[Amount])

If you want it as a measure:

Change sign = 
VAR _Code = LEFT(SELECTEDVALUE(Table1[Code]), 1)
RETURN
SWITCH(TRUE(),
_Code = "A", SELECTEDVALUE(Table1[Amount]) * -1,
_Code = "B", SELECTEDVALUE(Table1[Amount]) * -1,
SELECTEDVALUE(Table1[Amount]))

[AkshayManke]

Hello @PaulDBrown,

Thanks a ton for your help. The given dax is working exactly as expected. I have tried the column DAX and will try the measure as well.

Many thanks again!!

Regards,

Akshay