DAX measure to filter a date range

[hpayne93]

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

[hpayne93]

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]

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 👍

[hpayne93]

Worked perfectly thankyou!

[DOLEARY85]

No problem, happy to help 🙂

[DOLEARY85]

Hi,

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 👍