Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

max value selected in date slicer

I have a date slicer, I need to get the max of the date select to pass it as a parameter of a dax function :   I tried :   selected_date= CALCULATE(max('Calendar'[date]);(ALLSELECTED('Calendar'))...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Anonymous,

    If you want to create a new table and make it be dynamic with the slicer, I am afraid you could not achieve this feature currently, you could try to use the Top N filter in the visual filter to get your desired result:

    You could also download the pbix file to have a view.

     

    Regards,

    Daniel He

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

The issue here is that this part "MAX(Calendar[Date])" returns the most recent date (the last date in the whole Calendar range date) but not the last date selected with the slicer selection.

 

I have managed to get the correct date value (the last date selected with the slicer) by using a Measure but thateasure cannot be used here because it does not return the same value when used as a FilterExpression.

 

I understand that the underlying problem is the context of that Measure but I don't understand how to use Earlier() in that situation since you can't use that function with a Measure as a parameter.

SinghS's avatar
SinghS
Regular Visitor
3 years ago

Can you please tell, what change you did to the measure to get last date selected with the slicer selection and not the max date present in the calendar date