Forum Discussion
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 ...
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
Community Champion
Community ChampionI 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.
Thanks, that has done the job and is easier to reason about this way