Forum Discussion

BookBok's avatar
BookBok
New Member
7 years ago
Solved

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

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 US...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi BookBok,

     

    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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi BookBok,

 

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.