cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
singhmithsingh
Regular Visitor

Search a list of Items from another table

singhmithsingh_0-1618616149858.png

 

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.

1 ACCEPTED SOLUTION
Jihwan_Kim
Community Champion
Community Champion

Hi, @singhmithsingh 

Please check the below.

 

Creating a measure.

Picture2.png

Result measure =
VAR tabletwo =
VALUES ( Table2[ID] )
VAR resulttable =
EXCEPT ( tabletwo, VALUES ( Table1[ID] ) )
RETURN
CONCATENATEX ( resulttable, Table2[ID], ", " )
 
 
Creating a column
Picture3.png
 
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/

 

View solution in original post

2 REPLIES 2
Jihwan_Kim
Community Champion
Community Champion

Hi, @singhmithsingh 

Please check the below.

 

Creating a measure.

Picture2.png

Result measure =
VAR tabletwo =
VALUES ( Table2[ID] )
VAR resulttable =
EXCEPT ( tabletwo, VALUES ( Table1[ID] ) )
RETURN
CONCATENATEX ( resulttable, Table2[ID], ", " )
 
 
Creating a column
Picture3.png
 
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/

 

View solution in original post

it's working, Thank you😊

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors