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 🙂
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
2 Replies
- AlexisOlsonSuper 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 - HotChilliCommunity Champion
What result do you want?