Forum Discussion
Check if substring from column exists inside string in another table column
Greg_Deckler , correct me if I am wrong but I dont believe Text.Contains will work on its own as it doesnt work with a list of values... ?
Perhaps something like this instead:=Text.Contains(Text.Combine(informations[informations id]),[id])
Hi Mourad_Analyst ,
to my understanding of the problem, it seems to work alright (as the fields in information id don't seem to match those of the id column.
So maybe my understanding of the problem is incorrect.
Could you please upload sample data in a way so that it can be used to provide a correct answer:
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Also, please indicate what result exactly you expect for reach row of the sample data.
Agreed with this. Please provide some sample data and a sample output as to what you're expecting to accomplish. That will allow us to see things more clearly
