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 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
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.