topic Re: A Measure to Count Rows where a date is 30 days past today's date in DAX Commands and Tips

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

Gandarthvader — Mon, 16 Dec 2024 15:23:56 GMT

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!!

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

mark_endicott — Mon, 16 Dec 2024 15:40:49 GMT

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.

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

Gandarthvader — Mon, 16 Dec 2024 16:02:44 GMT

Thank you mark_endicott !