I have a Service Location table with related Service Location Repairs table. I have a deck view to display service locations that are scheduled in the [Today] date column to receive service. I’m trying to write an expression for a format rule that says if the in the completed service location repairs records the column [Timestamp] equals Today() then color the location name in the deck view green.
The deck view is build on the Service Locations table.
I’m using this but it isn’t working. IN(Today(), Service Location Repair[Timestamp])