Forum Discussion

Redacted_VAR's avatar
Redacted_VAR
Icon for Helper I rankHelper I
2 years ago
Solved

Non Exact Lookup Column Across Two Tables

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...
Need Help
  • DataInsights's avatar
    DataInsights
    2 years ago

    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

     

     

DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
2 years ago

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