SOLVED

Power Query - compare list of values with a column as COUNTIF Excel formula.

Deleted
Not applicable

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 the function "List.MatchesAny" with the following syntax :

List.MatchesAny({[A], [B], [C], [D], [E]}, each _ = [F])

But it doesn't work.

Someone to help me ?

2 Replies
best response
Solution

Hi Kriss,

 

Could be like

each List.Contains({[A],[B],[C],[D],[E]},[F])

 

Hi Sergei,

So simple with the right function !

Thx

1 best response

Accepted Solutions
best response
Solution

Hi Kriss,

 

Could be like

each List.Contains({[A],[B],[C],[D],[E]},[F])

 

View solution in original post