Forum Discussion

anisha's avatar
anisha
Regular Visitor
8 years ago
Solved

Get End date from relative date filter

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

2 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support

    anisha,

     

    You may refer to DAX below.

    Measure =
    VAR enddate = MAX ( 'Calendar'[Date] ) RETURN enddate
    
    • anisha's avatar
      anisha
      Regular Visitor

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