Forum Discussion

user180618's avatar
user180618
Icon for Helper I rankHelper I
3 years ago
Solved

Mapping columns from different tables where one has multiple delimited values

I have two tables that I would like to map together, either using a join or relationship or a lookup (not sure which is most appropriate). In Table 1 I have a column that lists English words/slang an...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi user180618 
    Please try

    Matched =
MAXX (
    FILTER (
        VALUES ( Table2[US_english] ),
        CONTAINSSTRING ( Table1[Word], Table2[US_english] )
    ),
    Table2[US_english]
)

    The MAXX shall not be required and can be removed

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

user180618 

Would you post a screenshot of the DAX code that you have used?

user180618's avatar
user180618
Icon for Helper I rankHelper I
3 years ago

Never mind, it worked now. I was doing it in Power Query not Power BI.

 

Thanks very much!