Solved: Boolean OR doesn't work

giuliapiazza94 · ‎04-07-2022

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 · ‎04-07-2022

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 · ‎04-07-2022

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 · ‎04-07-2022

What result do you want?

Boolean OR doesn't work