Forum Discussion
Solved
IF 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
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
So I used your logic and it's correct, thank you, HotChilli.
List.MatchesAny({[A], [B], [C], [D]}, each _ = true)