Replace multiple values using IF NOT while using one column as a reference

Question

Hi,In a table that has Countries and Regions I want to convert the Region to text "ALL" but not for 5 countries.This is, I want to keep the region only for Australia, Canada, China, India, and USA, any other Country I want to replace the region the account may have to ALL.I know how to do it in Excel, but I need it in PowerBI for a dinamic report.Where can I find the steps on how to create this column?Regards,

anonymous · Accepted Answer

Hi BookBok,&nbsp;You can create a new calculated column with following formula:New Region = 
If(table[Countries] in {"Australia","Canada","China","India","USA"},
   table[Countries], "All")I hope this help.

Forum Discussion

Replace multiple values using IF NOT while using one column as a reference

1 Reply

Related content

how to dynamically replace values for multiple columns

Table Replace Value multiple condition

Replace multiple values at once (replace value)

Replace References - changing data sources

Replace NULL