Conditional Format Timings

[rwcampbell]

Hello,

I have a few cards that show the last updated time and date for each of the tables on the system.

At the moment we have them set with this measure:

Collation Header Conditional Formatting = IF(MAX(CollationHeader[Updated])>=TODAY(),1,0) which looks at only the date.

Is there a way to look at the time which is included with the date and set it that if it passes 10 minutes after the current time, it highlights red otherwise it stays green?

Thanks.

[smpa01]

@rwcampbell  can you try this measure

Measure = IF(MINUTE(NOW()-calculate(max('Table'[time])))<=10,1,2)

[rwcampbell]

It is working but what should i set the background colours to?

[smpa01 · Accepted solution]

@rwcampbell  you can use the values from the above measure to set the background color

 such as 1=Green, 2=Red