Non Exact Lookup Column Across Two Tables

[Redacted_VAR]

Hi There,

i have two tables, one is attendees to an event, and the other is a master customer list:

EventTable:

Customer Name	Feedback Score
Bobs Burgers	8
Fine Foods	7
Smart Shopping Inc	9

MasterCustomer:

Customer Name	Industry
Bobs Burgers PLC	Industry 1
Fine Foods Limited	Industry 2
Smart Shopping Inc	Industry 3

I want to converge these tables, by creating a relationship between the two customer name columns, however they're not an exact match as the event table misses the formal company name. currently only the last customer is an exact match so a lookup column returns a blank for the first two - how do i create a lookup that looks for the presence of the text in event customer column inside the master customer column?

i want the following table as an output:

Customer Name	Feedback Score	Industry
Bobs Burgers PLC	8	Industry 1
Fine Foods Limited	7	Industry 2
Smart Shopping Inc	9	Industry 3

thanks in advance!

[Redacted_VAR]

thanks so much, that works and helps a bunch

[DataInsights · Accepted solution]

@Redacted_VAR,

Try this DAX calculated column in EventTable:

Industry = 
VAR vCustomerName = EventTable[Customer Name]
VAR vTargetRow =
    FILTER (
        MasterCustomer,
        CONTAINSSTRING ( MasterCustomer[Customer Name], vCustomerName )
    )
VAR vResult =
    MAXX ( vTargetRow, MasterCustomer[Industry] )
RETURN
    vResult