Highlight all the dates in the column

[BRL7WZ]

Hello,

Could someone please help me write a measure that will highlight all the dates in the column that reach today date in 30, 60 and 90 days. For example, if a document expires in 30 days the date colour will be red, if it expires in 60 days it will be orange and if it expires in 90 days it will be yellow.

I have searched the forum but have not found an answer....
Please help.

[BRL7WZ]

Thank you very much.
It works perfectly.
Have a great day.

[BRL7WZ]

Hi,

Yes I confirm, the data type in these columns is "date"

[johnyip · Accepted solution]

If you wish to highlight the data based on expired date (valid to), create this measure and then apply it in conditional formatting to both columns.

Color = SWITCH(TRUE(),
               AND(MAX([Valid to])-TODAY()>=0,MAX([Valid to])-TODAY()<=30),"red",
               AND(MAX([Valid to])-TODAY()>=31,MAX([Valid to])-TODAY()<=60),"orange",
               AND(MAX([Valid to])-TODAY()>=61,MAX([Valid to])-TODAY()<=90),"yellow"
)

[johnyip]

You should provide your sample data whose structure is identical to the actual data you are using. DAX cannot be written without knowing the data structure.

[BRL7WZ]

Hello,

My dates look like this:

Is this what you meant?

[johnyip]

Are the data type of the columns "date", or they are just text that look like a date?