Forum Discussion

hpayne93's avatar
hpayne93
Frequent Visitor
3 years ago

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 ...
Need Help
Tips and Tricks
hpayne93's avatar
hpayne93
Frequent Visitor
3 years ago

Ah actually I need to update it slightly! I need to capture the 'contact'[diagnoses date] in relation to 'book application'[sentdate]

 

I need to be able to quantify where the 'book application'[sent date] is within a year of the diagnoses date. Is that at all possible?

DOLEARY85's avatar
DOLEARY85
Icon for Resident Rockstar rankResident Rockstar
3 years ago

You should just be able to change the last date in the measure to 'book application'[sent date] 

 

If I answered your question, please mark my post as solution

 

Appreciate your Kudos 👍