Forum Discussion
Deleted
Mar 15, 2018Power 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 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 ?
Hi Kriss,
Could be like
each List.Contains({[A],[B],[C],[D],[E]},[F])
2 Replies
- SergeiBaklanDiamond Contributor
Hi Kriss,
Could be like
each List.Contains({[A],[B],[C],[D],[E]},[F])
- Deleted
Hi Sergei,
So simple with the right function !
Thx