Search a list of Items from another table

[Anonymous]

I am trying to acheive the column B, but I can't able to.

I want to search each items from table 2 in table 1, and if items is not there in Table 1 then return items in column B with comma seperated. please help me.

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please check the below.

Creating a measure.

Result measure =

VAR tabletwo =

VALUES ( Table2[ID] )

VAR resulttable =

EXCEPT ( tabletwo, VALUES ( Table1[ID] ) )

RETURN

CONCATENATEX ( resulttable, Table2[ID], ", " )

Creating a column

Result column =

VAR tableonecurrentselect = Table1[ID]

VAR tabletwo =

VALUES ( Table2[ID] )

VAR resulttable =

EXCEPT ( tabletwo, {tableonecurrentselect} )

RETURN

CONCATENATEX ( resulttable, Table2[ID], ", " )

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[Anonymous]

it's working, Thank you😊