Forum Discussion
Create new Column from Existing Data if Values are Found
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!!
I think you've removed a comma when editing the formula. The part before the <> should be
RIGHT('Tracked Issues'[Description],3),,999)
4 Replies
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
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!
I think you've removed a comma when editing the formula. The part before the <> should be
RIGHT('Tracked Issues'[Description],3),,999)
