Forum Discussion
Solved
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.
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
3 Replies
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
Thank you
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
