Find the value in other table

[VK7]

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.

[barritown · Accepted solution]

Hi @VK7,

One of the options is such a calculated column:

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]

Thank you

[barritown]

Okay, as you wish:

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