Forum Discussion

steambucky's avatar
steambucky
Helper III
8 years ago
Solved

Replace all different values except one

I have a column of data

 

Cat

Dog

Mouse

ANIMAL UNKNOWN

ANIMAL UNKNOWN

ANIMAL UNKNOWN

 

I want to replace everything except ANIMAL UNKNOWN TYPE with ANIMAL TYPE KNOWN.

 

I have far more than 3 types of animals - actually about 100. There loads of examples for getting rid of specific text but i can't find anything that gets rid of everything BUT a specific thing.  If you can help, the less coding or DAX stuff, the better. I am but a humble noob.  

 

Thanks in advance.    

Need Help
  • RahulYadav's avatar
    RahulYadav
    8 years ago

    Hi steambucky,

    You can use below dax formula to solve your problem.

     

    Resived Name = if(Animals[Name]<>"ANIMAL UNKNOWN","ANIMAL TYPE KNOWN",Animals[Name])

    Thanks,

    Rahul

2 Replies

  • RahulYadav's avatar
    RahulYadav
    Resolver II
    8 years ago

    Hi steambucky,

    You can use below dax formula to solve your problem.

     

    Resived Name = if(Animals[Name]<>"ANIMAL UNKNOWN","ANIMAL TYPE KNOWN",Animals[Name])

    Thanks,

    Rahul

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank you! This worked perfectly for me.