Power Query help - If text contains or text contains

[Matt22365]

Hi

I hope someone can help

I would like to use the add column feature of the query editor to search 2 columns of text and return a phrase if either contains what i am looking for.

I have written the formula but all it returns is errors, can anyone see the error in my formula?

if Text.Contains([Project Number], "ABCD") or Text.Contains ([Status 1],"ABCD") then "ABCD Related" else null)

Thanks for your help

Matt 

[az38 · Accepted solution]

@Matt22365 

what exactly error do you get? from my point everything look ok, except closed parenthesys ")" in the very end of your statement.

also be sure, your columns have a Text date type

[Matt22365]

Hi @az38 

Thanks for getting back to me so quick. One of the columns wasnst specified to Text. ive changed it and it works great now.

Thanks

Matt