Help With a conditional Formula based on Dates

[jesfree13]

I have a column in a table on my visual. with a date in it (some blanks). I need to color code the dates showing as follows

1. Dates 30  days out from todays date in Red (also some dates will be in the past)

2. Dates between 31 and 60 days in Yellow. 

3. Dates from 61+ in Green. 

Please help I have tried many things but just cannot get it to show correctly. I know it has something to do with the measure I am using. 

[ray_aramburo · Accepted solution]

Try this:

Date Logic = 
var days = DATEDIFF(TODAY(), Table[DateColumn], DAY)
RETURN
IF(days >= 61, "Green", IF(days >= 31 && days < 61, "Yellow", "Red"))

[jesfree13]

I am not sure where to enter that formula, Forgive my ignorance. 

[ray_aramburo]

No worries, that's why this forum exists 😀

Go to Home tab and find "New Measure"

In the Table[DateColumn] part just replace them with how they are named in your data.