Forum Discussion

giuliapiazza94's avatar
4 years ago
Solved

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

  • 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