A Measure to Count Rows where a date is 30 days past today's date

[Gandarthvader]

Hello,

We're trying to show a count of projects that are 30 days or more past their Integration date. I'm still pretty new at this, but I found how to make a measure counting projects that have integrated since today's date, but I didn't know if there was a place that I could just add a +30 or something to make it 30 days or more past today's date? Below is the measure I have right now.

Old Projects = COUNTROWS(FILTER('MPL',NOT(ISBLANK([Integration]))&&[Integration]<TODAY()))

Thanks!! 

[Gandarthvader]

Thank you @mark_endicott !

[mark_endicott · Accepted solution]

@Gandarthvader - try this:

VAR _30_days_ago = TODAY() - 30

RETURN
   COUNTROWS(FILTER('MPL',NOT(ISBLANK([Integration]))&&[Integration] > _30_days_ago ))

If this works, please accept it as the solution, it helps with the visibility for others with the same challenge.