Forum Discussion
Helper IFind if value contains anything from another column
Hi jasmith866 ,
You could try this calculated column.
T/F = IF ( SUMX ( 'Table (2)', FIND ( UPPER ( 'Table (2)'[Keywords] ), UPPER ( 'Table'[Field] ),, 0 ) ) > 0, "True", "False" )Reference: DAX – “CONTAINSX” – Finding if a value in table 1 has a matching value in table 2
You can check more details from here.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IThanks, but that doesn't seem to work - CONTAINSSTRING only accepts a single string for the search criteria so I can't pass it the column in table 2
Helper II am having simliar question and have been unable to come up with solution. In addition to your request, I am trying to have the desired column pull the string of text that is simliar between the two fields whereas in your example you are looking only for TRUE FALSE.
I will follow this thread to see if any ideas arise. This command didn't work for me either where Column A = Fred, Sam, Steve and Column B = Sam, Mike, Steve and Desired column = Sam, Steve
Text.Combine(List.Intersect(Text.Split([Column A],",") ,Text.Split([Column B],",")),",")