79410223

Date: 2025-02-03 23:12:00
Score: 0.5
Natty:
Report link

Let's call the boolean values A and B.

You have two options:

Both formulations simulate a XOR gate. The <> operator is effective a xor operator when applied to two booleans.

Example use case:

    #"Next Step" = Table.SelectRows(#"Previous Step", each ([NAME] = "Jim") <> ([AGE] = 2))

This would select all Jims and all 2-year olds, but not Jims who are two years old.

Reasons:
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: P. Hopkinson