Conditional Formatting this month, next month and 2 months time

[Jamieneedshelp]

Hi

I have matrix table with a reference column and a next review due date coloumn

I would like to highlight those in the current month green, next month amber and those in 2 months time red based on the date column example below

Hoping someone could suggest a dax measure I could apply for the conditional formatting many thanks

 

👍

[Undercoverstig]

Hi, thank you with your help with this however we have just noticed it also highlights the months from previous years also. I.e today it formats Sept 2022, Sept 2023, Sept 2024

Is there any way to add month and year to this? 

Thank you

[vicky_ · Accepted solution]

Try this dax:

FORMAT = SWITCH(MONTH(SELECTEDVALUE('Table'[Review Due Date])), 
    MONTH(TODAY()), "Green", 
    MONTH(TODAY()) + 1, "Orange", 
    MONTH(TODAY()) + 2, "Red"
)

[Grace_Pisarchuk]

I attempted this solution, but the formatting is not working. Any suggestions?

I want anything before today's date to be red, anything this month orange, and next month, yellow.