Change amount to Negative value based on True/False Column

[T_Francis]

Please help im a new user used to excel language and DAX has me stumped.

Id like to create a new column where the values in the amount colum are positive or negative based on the result of the refund column.

So where Refund = True the value in the new column would be minus whats in the amount column

so 125.96 would become -125.96 because the refund is TRUE.

Thank you in advance for helping me with this.

[harshnathani · Accepted solution]

Hi @T_Francis ,

Go to Power Query and Click on Add Column --> Custom Column

Type the above formula

if ([Refund]) then -[Amount] else [Amount])

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)