Get min and max values from date slicer

[stuross1129]

I am trying to retrieve the 2 date values used in my slicer and use in a Title text string.  What I can't figure out is how to pull the 2 date values from my slicer?  Note that I do not want to pull the minimum and maximum values from the underlying table with the date column, I want to pull the dates as selected in the slicer.

In this example if I select 1/1/2018 as the 1st date, the first date in my table is actually 1/7/2018.  I want to be able to get the 1/1/2018 date value, not the 1/7/2018 value in my data.  Think of it as what is the start and end of the reporting period.

[v-yulgu-msft · Accepted solution]

Hi @stuross1129,

Suppose you drag date field from date dimention table into slicer, to get the Max and Min date values from slicer selection, please create below measures:

MaxDate=MAX(DateDimention[Dates])

MinDate=MIN(DateDimention[Dates])

But if you want to show them dynamically in a Title Text, it is not available.

Regards,

Yuliana Gu