Forum Discussion
Helper IPower Query - ReplaceValues with two conditions
As an alternative, you could add a new column with the correct values and delete the old column.
That would enable you to work with a "replacements table" that you join on [Customer_ID] and [SM_Region] to your Customer Orders table.
Expand the new value and add a new column that checks if the new value is not null -> take the new value - otherwise - take the value from the original column.
Less typing and probably easier to maintain.
Community ChampionAs an alternative, you could add a new column with the correct values and delete the old column.
That would enable you to work with a "replacements table" that you join on [Customer_ID] and [SM_Region] to your Customer Orders table.
Expand the new value and add a new column that checks if the new value is not null -> take the new value - otherwise - take the value from the original column.
Less typing and probably easier to maintain.