Return value if cell contains text in another column

Hi CoronaAustralis ,

Here two solutions.

In Power Query:

Here the code:

= Table.AddColumn(#"Changed Type", "Custom", each if List.Contains(#"Changed Type"[Group 1] , [Group 2]) = true then "Yes" else null)

For reference:

https://www.tackytech.blog/how-to-swiftly-take-over-power-query/#4_Check_if_values_of_one_column_exist_in_another_column

In DAX:

Here the code:

Return Value =  IF ( CONTAINS ( Table9, Table9[Group 1], Table9[Group 2] ), "Yes", BLANK() )

For reference:

https://www.tackytech.blog/how-to-crack-the-mystery-of-the-mighty-dax/#check-if-values-of-one-column-exist-in-another-column

Hope this helps!

/Tom

https://www.tackytech.blog

https://www.instagram.com/tackytechtom