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