How to get selected date range from relative date slicer

[shashankg]

I have Relative date slicer and I want to pick exact date range which is selected in drop down.

Is it possible?
Example – Suppose slicer have following value – I want to get exact date range that is 11/18/2021 - 11/24/2021 and store in some variable

[shashankg]

@Greg_Deckler Thanks for your reply,

MIN('Table'[Date]) and  MAX('Table'[Date]) gives values from the table. I don't want values from table. for eg, as shown in image,

I want

var 1 = "Last 1 weeks"

var2 =  11/18/2021

var3 = 11/24/2021

These values are coming from relative date slicer.

[v-zhengdxu-msft]

Hi @shashankg 

Unfortunately, Power bi doesn't support this feature currently, you can't get the value which doesn't exist in your table.

The slicer is just another way of filtering, which can only filter based on the values you already have.

Best Regards

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

[Greg_Deckler · Accepted solution]

@shashankg Yes, as measures:

MinDate = MIN('Table'[Date])

MaxDate = MAX('Table'[Date])

Inside a measure:

VAR __MinDate = MIN('Table'[Date])

VAR __MaxDate = MAX('Table'[Date])