Create new Column from Existing Data if Values are Found

[KarlConstruct]

Hi All, 

I've created a new column that searches the text of another column and if any of the text matches another table I have setup, then it returns that value. 

The new column is: 

Comments By = VAR result = 
CONCATENATEX('ID Matrix',IF(SEARCH(FIRSTNONBLANK('ID Matrix'[ID Extract],1),'Tracked Issues'[Description],,999) <> 999,'ID Matrix'[ID Extract],"")) Return IF( result <> Blank(),result,"Not Found")

The ID table looks like this. 

My end result is this (below) with a new column being added that displays the inspectors initials if they've added them at the end of their description. As you can see its also finding those same matches in the middle of other words and then combines the two in the new column.  

I know this has to be fairly simple, i'm still very new and more complex power BI so any help would be greatly appreciated!!

[HotChilli]

I suppose you could limit the search by replacing the text to be searched  

'Tracked Issues'[Description]

with

RIGHT('Tracked Issues'[Description],3)

 Feel free to experiment

[KarlConstruct]

That makes a lot of sense to limit the search to the last few characters as thats where they typically leave their initials. Thank you for that. 

I seem to be doing something wrong here, any thoughts on my code? 

thank you!

[HotChilli · Accepted solution]

I think you've removed a comma when editing the formula. The part before the <> should be

RIGHT('Tracked Issues'[Description],3),,999)

[KarlConstruct]

That worked thank you! 

Not sure if there is an easier way to do this in powerBI but this will work fine for now!