Check If Value in Column A is contained in Column B

[drmccoy]

Hello,

I am trying to set up a new column in my dataset to find out if the value in column A is contained within column B. I was hoping someone has come across this and knows a good solve for it. I appreciate any insight anyone might be able to provide on how to make this comparison within PowerBI. 

For example:

Column A = "Testing"

Column B = "00TestingCD"

MatchField = If(<ColumnB> Contains <ColumnA>,"Match","No Match")

[Vvelarde · Accepted solution]

@drmccoy 

Hi, in Query Editor

Regards

Victor