Forum Discussion
Post Patronin Power Query: If 2 columns contain specific text then this, else, this
Hi electrobrit
As a custom column
=Text.Contains([Column A],"arlene",Comparer.OrdinalIgnoreCase) and Text.Contains([Column B],"arlene",Comparer.OrdinalIgnoreCase)
electrobrit wrote:The column results are "error"
What was the error?
electrobrit wrote:1. how do I add the Yes if true, no if not? I tried to add at end and it didn't work.
= if Text.Contains([Column A],"arlene",Comparer.OrdinalIgnoreCase)
and
Text.Contains([Column B],"arlene",Comparer.OrdinalIgnoreCase) = true then "YES" else "NO"
electrobrit wrote:2. it would not take the "and" so I used "&" and it seemed to work when doing custom column (it said not syntax error have been detected) but is that correct for what I'm trying to do?
'and' worked for me, unsure why it did not work for you
Resident Rockstar
electrobrit wrote:The column results are "error"
What was the error?
electrobrit wrote:1. how do I add the Yes if true, no if not? I tried to add at end and it didn't work.
= if Text.Contains([Column A],"arlene",Comparer.OrdinalIgnoreCase)
and
Text.Contains([Column B],"arlene",Comparer.OrdinalIgnoreCase) = true then "YES" else "NO"
electrobrit wrote:2. it would not take the "and" so I used "&" and it seemed to work when doing custom column (it said not syntax error have been detected) but is that correct for what I'm trying to do?
'and' worked for me, unsure why it did not work for you
Post PatronChris Thanks, I didn't have the "if" in front.That worked perfectly.
Thank you for both Zubair_Muhammad and ChrisMendoza for the great help