Search text from one table and match from another table add column

[Anonymous]

Hi,

Is it possible to do this with power bi: I have two tables, 'ToteutetutChanget' and 'Data'.

I need  to search Values in ToteutetutChanget[Tiketti] from Data[Comment] and add column to Data table which includes the search string. Data[Comment]column contains free text and somewhere in the column row there is always the ticket number which to find.

Data[comment looks like this

ToteutetutChanget[Tiketti] (these are the search values, column row contains only the ticket id like this)

[Anonymous]

The solution is often easier than you thought of. Thanks this is obviously the way to go 🙂

[Gabriel_Walkman · Accepted solution]

How about you split the comment column with delimiter of " ", extract as rows and filter to ones that include "REQ"?

I don't get the need for the separate Tiketti column in this case. Then you could just create a relationship. Eli molemmista tauluista löytyy sit tiketti, niiden välille vaan relationship jos on tarvetta.