Forum Discussion

vojtechsima's avatar
vojtechsima
Icon for Super User rankSuper User
3 years ago
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...
Need Help
  • HotChilli's avatar
    HotChilli
    3 years ago

    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

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
3 years ago

 

= Table.AddColumn(#"Changed Type", "Result", each not List.Contains(Record.ToList(_),false))

 

vojtechsima's avatar
vojtechsima
Icon for Super User rankSuper User
3 years ago

CNENFRNL 
Thank you for the effort, this checks if every column is the TRUE, right?
This doesn'T suit me, very well, in my real scenario but I agree, my example wasn't the best.

So thank you  for the effort.