Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
👍
Solved! Go to Solution.
Try this dax:
FORMAT = SWITCH(MONTH(SELECTEDVALUE('Table'[Review Due Date])),
MONTH(TODAY()), "Green",
MONTH(TODAY()) + 1, "Orange",
MONTH(TODAY()) + 2, "Red"
)
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
Try this dax:
FORMAT = SWITCH(MONTH(SELECTEDVALUE('Table'[Review Due Date])),
MONTH(TODAY()), "Green",
MONTH(TODAY()) + 1, "Orange",
MONTH(TODAY()) + 2, "Red"
)
User | Count |
---|---|
69 | |
43 | |
21 | |
21 | |
14 |
User | Count |
---|---|
124 | |
42 | |
39 | |
28 | |
25 |