Forum Discussion

DeepDive's avatar
DeepDive
Icon for Helper IV rankHelper IV
7 years ago
Solved

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

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 :

Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    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.

     

2 Replies

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support
    7 years ago

    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.