Boolean OR doesn't work

[giuliapiazza94]

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 🙂

[AlexisOlson · Accepted solution]

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

[HotChilli]

What result do you want?