Check whether a String contains any elements of a column

[meiwah]

Hi,

If I've a table Customers and tells the fruits each customer likes, then I've another table contains all local fruits. I would like to find out what local fruits each customer likes. Pls kindly advise how to achieve this in Power Query. Thanks!

[slorin · Accepted solution]

Hi,

With

Fruits = #"Local Fruits"[Fruit]

add column 

(x) => Text.Combine(List.Select(Fruits, each Text.Contains(x[Likes], _))," ") 

 Stéphane