Conditional expression with OR question

[Khramana]

Hello Power BI masters!

I faced with a difficulty to make the right conditional expression with logic "OR".
I have table like this:

Ticket number	Title	Description	Keyword
1234	I like bananas	bananas are the best	Apples
12345	I like bananas	but apples more	Apples
54321	I like apples	and nothing more	Apples

I want to add an additional column to my table which will check whether columns Title or Description contains any word in Keyword column. If any of them contains it - then 1. If noone contains - then 0.

I can check it perfectly checking in 1 column like:
Table.AddColumn(#"Expanded Keywords", "Custom", each if Text.Contains([Description], [KeyWords.1]) then 1 else 0)

But I don't fully understand how to add "OR" condition here correctly.
May be  "IN" needs to be used here... but I'm a bit lost... 
Could you please advise?

Thank you very much in advance!

[Vijay_A_Verma · Accepted solution]

Use

Table.AddColumn(#"Expanded Keywords", "Custom", each if Text.Contains([Description], [KeyWords.1]) or Text.Contains([Title], [KeyWords.1]) then 1 else 0)

Since you have got case-sensitivity

= Table.AddColumn(#"Renamed Columns", "Custom", each if Text.Contains([Description], [Keyword.1], Comparer.OrdinalIgnoreCase) or Text.Contains([Title], [Keyword.1], Comparer.OrdinalIgnoreCase) then 1 else 0)

[Khramana]

Thank you, @Vijay_A_Verma  but it's strange, that in case of 2nd formula use, it adds the whole initial table too (double the initial table + adds a custom column).
Also custom column often shows an error inside or only 0. But there are tickets that have the word "Apples" inside. Do you know what could go wrong? 

[Vijay_A_Verma]

Replace #"Renamed Columns" with your previous step.

I want to see some sample data where it shows error or 0?

[Khramana]

I guess I found out a possible reason why it could happen - if one of the columns is blank - in this case it showed error.