topic how to add a value from another table when a string contains this value? in DAX Commands and Tips

how to add a value from another table when a string contains this value?

yyyy — Fri, 07 Oct 2022 00:09:23 GMT

I need some help to achieve this, hope someone can help.

I have a table with a column named 'Title'.

I have another table with a column named 'Code'.

What I need to achieve is:
If table1.Title contains a value that is present in tabl2.Code, I want to see this code in Table1.

Example:

Table1
CODE

ABC

DEF

XYZ

Table2 has a column TITLE, and I want to add a column CODE.

Example:

CODE TITLE

DEF this title contains DEF, so I want to see this as code

ABC this title contains ABC
this title contains QQQ. QQQ is not present in table one, so code must stay empty

Re: how to add a value from another table when a string contains this value?

tamerj1 — Fri, 07 Oct 2022 01:46:19 GMT

Hi yyyy
Seems there is some confusion or typo mistakes in the question. I will assume that Table2 has the column [Title] that is a text which might contain one of codes available in Table1[Code] and you want to create a new column in Table2 that contains the code from Table1 if it existis with the title text otherwise return blank.

Code = IF ( NOT ISEMPTY ( FILTER ( Table1, CONTAINSSTRING ( Table2[Title], Table1[Code] ) ) ), Table1[Code] )

Re: how to add a value from another table when a string contains this value?

EvL1973 — Fri, 07 Oct 2022 15:03:48 GMT

I think the provided solution doesn't work:

I used this to test it:

Table1

Table 2

New calculated column in table 2:

Re: how to add a value from another table when a string contains this value?

tamerj1 — Fri, 07 Oct 2022 16:00:33 GMT

EvL1973

You are right. Following is amended

Code = VAR T1 = FILTER ( Table1, CONTAINSSTRING ( Table2[Title], Table1[Code] ) ) RETURN IF ( NOT ISEMPTY ( T1 ), MAXX ( T1, Table1[Code] ) )