How to get both values of Slicer (Using between Option)

[DeepDive]

I am using below slicer (by using between option), i need both minimum and maximum year value as want to use the both values in dax, kindly help how to get those values :

[v-xicai · Accepted solution]

Hi @DeepDive ,

You can create measures to get Max date and Min date of date slicer like DAX below:

Max date = CALCULATE(MIN(CalendarDate[Date]),ALLSELECTED(CalendarDate[Date]))

Min date = CALCULATE(MAX(CalendarDate[Date]),ALLSELECTED(CalendarDate[Date]))

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DeepDive]

 Thanks @v-xicai