Colour expression

[JoseGarcia]

Hi there, 
Want to make a look ahead condition if greater than today, red, green.

Using formula: 

=If(Month(Avg([EightD.D1_KPIDate])+241) > Month(Today()), RGB(0,255,0), RGB(255,0,0))

But I am getting this result (Dec2023 should be red)
any ideas? Thank you

[PhanThanhSon]

Hey,

Your condition needs to be adjusted based on the dimension and not on your measure, as you're considering the dimension. In other words, in clear terms:

IF(DateDim > today(), RGB(0,255,0), RGB(255,0,0))

If your dimension is not of type CalendarType, you would need to cast your calendar:

Date(Date#(DateDim, 'MMM YYYY'), 'MMM YYYY') 

Where DateDim is your dimension.

Best regards Son

[JoseGarcia]

Hi there, 
tried both expressions, no luck 😞

IF([EightD.D1_KPIDate]+241> today(), RGB(0,255,0), RGB(255,0,0))

if(Date(Date#(EightD.D1_KPIDate, 'MMM YYYY'), 'MMM YYYY')+241 > today(), RGB(0,255,0), RGB(255,0,0))

[JoseGarcia · Accepted solution]

Hi there, 
This expression worked!

IF(Avg([EightD.D1_KPIDate]+241> today()), RGB(25,170,110), RGB(220,50,35) )