Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
KarlConstruct
Frequent 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: 

 

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. 

ID Matrix.png

 

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.  

name extract.png

 

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!!

 

1 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)

 

View solution in original post

4 REPLIES 4
HotChilli
Super User
Super User

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? 

name extract 2.png

 

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! 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.