Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Excel AND function, but, in power query

Hello guys, hope you're good!   I have the following formula in excel, and im trying get the same results in power query:   I tried to use the conditional column in Power Query, but it retu...
Need Help
  • jennratten's avatar
    jennratten
    2 years ago

    Hello - you could do it like this:

    = Table.AddColumn(#"Changed Type", "Custom", each if List.AllTrue ( { [Column2]="OK",[Column3]="OK",[Column4]="OK",[Column5]="OK",[Column6]="OK" } ) then "OK" else "NOTOK", type text)

     

     

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    2 years ago

    Use this in a custom column

    if List.Contains(List.Range(Record.ToList(_), 1, 5), "NOTOK") then "NOTOK" else "OK"
Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
2 years ago

Use this in a custom column

if List.Contains(List.Range(Record.ToList(_), 1, 5), "NOTOK") then "NOTOK" else "OK"