Date Range Parameters

[Anonymous]

I have after date slicer and before date slicer on 'Date'[St_Date] and 'Date'[end_date] i want to show selected date

I have written an measure as below

Range= "From" & selectedvalue('Date'[St_Date]) & "to" selectedvalue('Date'[St_Date])

Output: From to

I want output: from 01/01/1900 to 31/12/9999

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

For selectedvalue returns the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns alternateResult.

You need to adjust your formula as below:

Range = "From" & MIN('Date'[St_Date]) & "to" &MAX('Date'[end_date])

Best Regards,

Lin

[Anonymous]

Hi,

This formula works but when user selects date before 2016(for eg. 01/01/2010 ) it is still showing 2016 cause my date table have relationship with other table"s effective date and it's minimum date is 2016.

I can't make my relationship inactive between these two tables.

So is there any way so that i can display whatever user selects the date in before/after date slicer.

[v-lili6-msft]

hi, @Anonymous 

If so, please adjust the formula as below:

Range = "From" & MIN( "field in Start Date slicer" ) & "to" &MAX( "field in End Date slicer" )

If not your case, please share your simple sample data with your expected output.

Best Regards,

Lin

[Anonymous]

ur previous measure is correct.

i have after/before date slicer.

user can select any date. but the date column is mapped with effective date of other table in relationship.

and effective values are 01-01-2016 onwards only.

if user selects 01-01-2010 in date slicer so still it is giving result 01-01-2016 as we are using min ('date'[st_Date])

I need output like whatever user selects that should  display.

[v-lili6-msft]

hi, @Anonymous 

Yes, just replace min (the field in date slicer ) with min ('date'[st_Date]).

Best Regards,

Lin