Forum Discussion
Conditional Formatting of Dates
I have expiration dates as a column. I want the date to turn red if it is within 90 days of today. I would like to do the same with another column "Order by" if it is within 2 weeks.
Anonymous Try creating a flag measure and using it in a rule.
Flag Measure = VAR __ExDate = MAX('Table'[Expiration Date]) VAR __Days = (TODAY() - __ExDate) * 1. RETURN IF(__Days > 90,1,0)
Greg_Deckler
Community Champion
Community ChampionAnonymous Try creating a flag measure and using it in a rule.
Flag Measure =
VAR __ExDate = MAX('Table'[Expiration Date])
VAR __Days = (TODAY() - __ExDate) * 1.
RETURN
IF(__Days > 90,1,0)