Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
VK7
Frequent Visitor

Find the value in other table

Hi,
Need to achieve column C in table 1, By considering the logic if Table 1, Column B value is in Table 2 Column B then True else False.

1 ACCEPTED SOLUTION
barritown
Super User
Super User

Hi @VK7,

One of the options is such a calculated column:

barritown_1-1708631524271.png

In plain text for convenience:

Column C = 
VAR stringToCheck = CONCATENATEX ( Table2, [Column B], "; " )
RETURN CONTAINSSTRING ( stringToCheck, [Column B] )

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian

View solution in original post

3 REPLIES 3
barritown
Super User
Super User

Hi @VK7,

One of the options is such a calculated column:

barritown_1-1708631524271.png

In plain text for convenience:

Column C = 
VAR stringToCheck = CONCATENATEX ( Table2, [Column B], "; " )
RETURN CONTAINSSTRING ( stringToCheck, [Column B] )

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian

VK7
Frequent Visitor

Thank you

Okay, as you wish:

barritown_0-1708677029395.png

Column C as Measure = 
VAR currentB = SELECTEDVALUE ( Table1[Column B] )
VAR stringToCheck = MAX ( Table2[Column B] )
RETURN CONTAINSSTRING ( stringToCheck, currentB )

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.