How to get the CHOSEN start and end points of time slider (slicer)?

[Finnair]

I have a data table (Mytable) with Modified date column. I need to get the start and end parameters of the slider eg. points that are chosen (not the start/end of the scale).

I have tried this chosen start:

ChosenStart = CALCULATE(MIN(Mytable[Modified].[Date]), ALLSELECTED(Mytable[Modified].[Date]))

But this gives me only the start date of the year.

What would be the right formula?

[amitchandak]

@Finnair , Not very clear. Example to get mon nad max value on a range slicer

new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = minx(allselected(Date1),Date1[Date])

return

calculate( sum(Table[Value]), filter('Table', 'Table'[Date] >=_min && 'Table'[Date] <=_max))

[Finnair]

Thank you @amitchandak 

With your var_max I get maxdate correctly.

My slider is a "between" slider.

With var_min I don't get the mindate.

[v-easonf-msft · Accepted solution]

Hi, @Finnair 

ChosenStart = CALCULATE(MIN(Mytable[Modified].[Date]), ALLSELECTED(Mytable[Modified].[Date]))

Is Mytable[Modified] the date field you are currently using?

You should use Mytable[Modified].[Date] rather than Mytable[Modified] here to get  the chosen start and end points of time slider.

ChosenStart = MIN(Mytable[Modified])

ChosenEnd = Max(Mytable[Modified])

Please check my sample file for more details.

Best Regards,
Community Support Team _ Eason