Forum Discussion
giuliapiazza94
4 years agoHelper IV
Boolean OR doesn't work
Hi guys, I've written a dax function with OR but it doesn't work and I don't kwon why If I write them separately, them work Can you help me please? Thank you 🙂 ...
- 4 years ago
Note that A<>B || A<>(B-1) is always true since A cannot be both B and B-1 simultaneously.
I think what you might actually be after A is not equal to either, in which case you'd use && instead.
NOT ( A = B || A = B - 1 )is logically equivalent to
A <> B && A <> B - 1
AlexisOlson
4 years agoSuper User
Note that A<>B || A<>(B-1) is always true since A cannot be both B and B-1 simultaneously.
I think what you might actually be after A is not equal to either, in which case you'd use && instead.
NOT ( A = B || A = B - 1 )
is logically equivalent to
A <> B && A <> B - 1