Forum Discussion
How to Highlight Past months
Hi dharish20240911,
Thanks for Kaviraj11 reply.
You can try the following steps
Sample dataDate Value1 Value2
5//1/2024 5 7
6/1/2024 4 8
7/1/2024 7 4
8/1/2024 3 9
9/1/2024 9 5Create a mesasure
IsCurrentMonth = IF( MONTH(SELECTEDVALUE('Table'[Date])) < MONTH(TODAY()), "Red", "Black" )Apply the measure to the format
Final outputBest regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi dharish20240911,
Thanks for Kaviraj11 reply.
You can try the following steps
Sample data
Date Value1 Value2
5//1/2024 5 7
6/1/2024 4 8
7/1/2024 7 4
8/1/2024 3 9
9/1/2024 9 5
Create a mesasure
IsCurrentMonth =
IF(
MONTH(SELECTEDVALUE('Table'[Date])) < MONTH(TODAY()),
"Red",
"Black"
)
Apply the measure to the format
Final output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
This above solution is also highting the months for Oct , Nov and December if the current month is Sep
Hi dharish20240911 ,
I've added a couple of later dates to the original data and still only highlight the first few months, so you can check that all your steps are working.Best regards,
Albert He