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 @ sta...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    anisha,

     

    You may refer to DAX below.

    Measure =
VAR enddate = MAX ( 'Calendar'[Date] ) RETURN enddate
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

anisha,

 

You may refer to DAX below.

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

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