How to make the if condition for the negative values?

[bourne2000]

Hi

This is follow up to my previous post

I have the expiration date column as below

I calculated no of days from the expiration column using the below measures

No of days = DATEDIFF( 'Expiration Days'[Current Expiration Date],TODAY(), DAY)

I want to calculate a new column called status with the following condition,

If no of days is within 60 days then I need to create "Expired within 60 days"

If no of the day's Will Expire < 1 Week  from Today's date then I need to create “In 1 Week” 

If no of the day's Will Expire < 2 Weeks  from Today's date then I need to create “In 2 Weeks” 

I used the below dax measure

Status = 
IF('Expiration Days'[No of days] > 0 && 'Expiration Days'[No of days] =60, "Expired within 60 days",
IF( 'Expiration Days'[No of days] <= 0 && 'Expiration Days'[No of days] <= -7, "Expire in 1 week", 
IF( 'Expiration Days'[No of days] <= -7 && 'Expiration Days'[No of days] <= -14, "Expire in 2 weeks", "No"))

Negative values condition is not working, I am getting below

Can anyone advise? People in the previous posts helped me to rectify it, however, it's not working. 

[SteveHailey · Accepted solution]

Hi @bourne2000. I would do it something like this:

Status = 
VAR NumDays = [No of days]
VAR Result =
SWITCH(
    TRUE(),
    NumDays <= -14, "Expire in 2 weeks", 
    NumDays <= -7, "Expire in 1 week",
    NumDays >= 0 && NumDays <= 60, "Expired within 60 days",
    "No"
)
RETURN Result