Forum Discussion
vojtechsima
Super User
Super UserIF Multiple Columns equal to Value (Power Query M)
Hello, guys, I need to know if there's a formula or function that lets me list columns and if those columns equal to a certain value on each row I want to return some value.
For example:
A...
You can use List.MatchesAny but what's the logic of the second line being equal to FALSE? If it follows the logic of the code you provided (each condition with an 'or'), it's TRUE
HotChilli
Community Champion
Community ChampionYou can use List.MatchesAny but what's the logic of the second line being equal to FALSE? If it follows the logic of the code you provided (each condition with an 'or'), it's TRUE
- vojtechsima
HotChilli ,
Yeah my bad, I didn'T really check the logic, it was just to give an example, that I need to check multiple columns. - vojtechsima
HotChilli
So I used your logic and it's correct, thank you, HotChilli.List.MatchesAny({[A], [B], [C], [D]}, each _ = true)
