Get End date from relative date filter

[anisha]

Hi,

I want to create a measure where I will filter records based on user selected End date.

(i.e. if user choose last 2 years from relative date filter than @Enddate will be 31/12/2017 and @ startdate will be 1/1/2016)

Then I want to put condition like fact[EndDate]>@enddate in measure.

 How I can get the value of @enddate in a measure.

Thanks,

Anisha

[v-chuncz-msft · Accepted solution]

@anisha,

You may refer to DAX below.

Measure =
VAR enddate = MAX ( 'Calendar'[Date] ) RETURN enddate

[anisha]

Yes, its giving correct value but when used in creating measure or calculating column, its not filtering records accordingly.