The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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:
Product | Comment | Result |
ABC | apple banana cherry | True |
BCD | apple orange lemon | True |
CDE | coconut watermelon mango | False |
LookUp:
Product | Comment |
ABC | kiwi |
ABC | banana |
BCD | orange |
BCD | mango |
CDE | apple |
CDE | cherry |
CDE | banana |
Solved! Go to Solution.
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
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