Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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!!
Solved! Go to Solution.
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!
User | Count |
---|---|
59 | |
59 | |
56 | |
38 | |
29 |
User | Count |
---|---|
80 | |
62 | |
45 | |
40 | |
39 |