Power BI - If with AND and OR

[obriaincian]

Hi All,

I have the following DAX Calculated column formula which isn't executing correctly

CheckStatus =

IF('Data'[DaysUntilExpiry] >-100 && 'Data'[DaysUntilExpiry]<=0 && 'Data'[DaysUntilExpiry_PreviousMonth] <-100 || 'Data'[DaysUntilExpiry_PreviousMonth]>0, "Check Product")

Formula break down:

I have 2 columns: DaysUntilExpiry & DaysUntilExpiry_PreviousMonth.

What I want to do is output "Check Product" if;

DaysUntilExpiry is >-100 AND < 0

AND

DaysUntilExpiry_PreviousMonth is <-100 OR >0

The formula works for "DaysUntilExpiry is >-100 AND < 0" But when the second part is added it executes but the output is incorrect.

Data

DaysUntilExpiry	DaysUntilExpiry_PreviousMonth
-2	1
-102	2
-5	-10

Expected Output

DaysUntilExpiry	DaysUntilExpiry_PreviousMonth	CheckStatus
-2	1	Check Product
-102	-1
-5	-10

Thanks

[obriaincian · Accepted solution]

Answer

CheckStatus =
IF (
    'Data'[DaysUntilExpiry] >-100 
      && 'Data'[DaysUntilExpiry]<=0 
      && 
       (
         'Data'[DaysUntilExpiry_PreviousMonth] <-100 
          || 'Data'[DaysUntilExpiry_PreviousMonth] > 0 
       ),
    "Check Product"
)