Forum Discussion
Solved
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: Co...
I think you've removed a comma when editing the formula. The part before the <> should be
RIGHT('Tracked Issues'[Description],3),,999)
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)That worked thank you!
Not sure if there is an easier way to do this in powerBI but this will work fine for now!
