Forum Discussion

T_Francis's avatar
T_Francis
Frequent Visitor
6 years ago
Solved

Change amount to Negative value based on True/False Column

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.

 

  • Anonymous's avatar
    Anonymous
    6 years ago

    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)

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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)