Forum Discussion

steambucky's avatar
steambucky
Icon for Helper III rankHelper 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 tha...
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

RahulYadav's avatar
RahulYadav
Icon for Resolver II rankResolver 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.