Mar 15 2018
09:37 AM
- last edited on
Jul 12 2019
11:05 AM
by
TechCommunityAP
Mar 15 2018
09:37 AM
- last edited on
Jul 12 2019
11:05 AM
by
TechCommunityAP
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 ?
Mar 15 2018 10:09 AM
SolutionHi Kriss,
Could be like
each List.Contains({[A],[B],[C],[D],[E]},[F])
Mar 15 2018 10:18 AM
Hi Sergei,
So simple with the right function !
Thx
Mar 15 2018 10:09 AM
SolutionHi Kriss,
Could be like
each List.Contains({[A],[B],[C],[D],[E]},[F])