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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
EZiamslow
Helper III
Helper III

M: If text contains in look up table that match criteria, then True

Hi,

How do I go about doing this? I'm trying to get Result column by looking at LookUp table.

 

If text contains in LookUp table that match the Product, then True else False.

 

Table1:

ProductCommentResult
ABCapple banana cherryTrue
BCDapple orange lemonTrue
CDEcoconut watermelon mangoFalse

 

LookUp:

ProductComment
ABCkiwi
ABCbanana
BCDorange
BCDmango
CDEapple
CDEcherry
CDEbanana
1 ACCEPTED SOLUTION
slorin
Super User
Super User

Hi @EZiamslow 

 

let
Source = Table.NestedJoin(Table1, {"Product"}, LookUp, {"Product"}, "LookUp", JoinKind.LeftOuter),
Result = Table.AddColumn(Source, "Result", each List.ContainsAny(Text.Split([Comment], " "), [LookUp][Comment]))
in
Result

Stéphane 

View solution in original post

2 REPLIES 2
EZiamslow
Helper III
Helper III

@slorin Awesome, thanks! 

slorin
Super User
Super User

Hi @EZiamslow 

 

let
Source = Table.NestedJoin(Table1, {"Product"}, LookUp, {"Product"}, "LookUp", JoinKind.LeftOuter),
Result = Table.AddColumn(Source, "Result", each List.ContainsAny(Text.Split([Comment], " "), [LookUp][Comment]))
in
Result

Stéphane 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors