Forum Discussion
DAX measure to filter a date range
Hi, I'm struggling to filter my measure within a time range. I need to CALCULATE(COUNTROWS) of my 'Contact' whereby their 'contact[Diagnosis Date] is within the last year. Any tips would ...
DOLEARY85
Resident Rockstar
Resident RockstarHi,
try something like this:
Last Year Days = CALCULATE (
COUNTROWS( 'Table'),
DATESINPERIOD ( 'Table'[update date], LASTDATE ( 'Table'[update date] ), -1, YEAR )
)
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍