Forum Discussion

Deleted's avatar
Deleted
Mar 15, 2018
Solved

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 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

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    Hi Kriss,

     

    Could be like

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

     

    • Deleted's avatar
      Deleted

      Hi Sergei,

      So simple with the right function !

      Thx

Resources