Hi @paw1 ,
Please try below steps;
1. below is my test table
2. create measure with below dax formula
VAR _a =
SELECTEDVALUE ( 'Table'[Today Date] )
VAR _b =
SELECTEDVALUE ( 'Table'[Closed Date] )
VAR _day =
DAY ( _b )
IF ( AND ( DATEDIFF ( _b, _a, MONTH ) = 1, _day = 1 ), "yellow" )
3. set conditional format background color for fields
Please refer the attached .pbix file.
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.