Forum Discussion

mangopop's avatar
mangopop
Frequent Visitor
10 years ago
Solved

alter values in one column based on a value in another column

I would like to change the values to negative values in a column based on whether another column value is 0 or 1   I'm using the advanced query editor (Power Query?) but I'm stuck on a few things ...
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    I would just create a new column with a formula of:

     

    = if [Indicator Column] = 1 then [Value Column] * -1 else [Value Column]

     

    Then, you could remove your original column and rename this new column to that column name.

     

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

I would just create a new column with a formula of:

 

= if [Indicator Column] = 1 then [Value Column] * -1 else [Value Column]

 

Then, you could remove your original column and rename this new column to that column name.

 

 

mangopop's avatar
mangopop
Frequent Visitor
10 years ago

Thanks, that has done the job and is easier to reason about this way