topic Re: Conditional Formatting this month, next month and 2 months time in DAX Commands and Tips

Conditional Formatting this month, next month and 2 months time

Jamieneedshelp — Tue, 22 Aug 2023 22:19:33 GMT

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

👍

Re: Conditional Formatting this month, next month and 2 months time

vicky_ — Tue, 22 Aug 2023 22:50:19 GMT

Try this dax:

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

Re: Conditional Formatting this month, next month and 2 months time

Undercoverstig — Wed, 06 Sep 2023 14:43:14 GMT

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

Re: Conditional Formatting this month, next month and 2 months time

Grace_Pisarchuk — Thu, 08 Aug 2024 17:01:44 GMT

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.