Forum Discussion
Search text from one table and match from another table add column
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 Dat...
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.
The solution is often easier than you thought of. Thanks this is obviously the way to go 🙂