Forum Discussion
Power Query - compare list of values with a column as COUNTIF Excel formula.
Hi,
In Power Query I have a table with 6 column : [A], [B], [C], [D], [E], [F] each as Text.
I need a new one to check if at least one of column [A] to [E] has the same value than [F].
I tried ...
Hi Kriss,
Could be like
each List.Contains({[A],[B],[C],[D],[E]},[F])
Hi Kriss,
Could be like
each List.Contains({[A],[B],[C],[D],[E]},[F])
Hi Sergei,
So simple with the right function !
Thx