I have a column of data
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.
Solved! Go to Solution.