Conditional Form at date that occurred in past 30 days

[Jason_Auburn]

Hello

I would like to fill a cell within a table if a date is present that occurred within the past 30 days as green and if it's more than 30 days fill with red. 

The column is called 'Incidents'[IN Last Comment], I understand this will need a measure to be created then added as conditional formatting?

[Anonymous · Accepted solution]

Hi @Jason_Auburn 

You can create a measure

e.g 

Format = var a=DATEDIFF(SELECTEDVALUE('Incidents'[Date]),TODAY(),DAY)
return IF(a>0&&a<=30,"green","red")

Then put it to the conditional formatting of the [in last comment] field

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[chonchar]

Yes. Put that measure in a visual, then:

Click that little FX

 Updating Media