Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Date Range Parameters

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...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    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's avatar
Anonymous
Not applicable
7 years ago

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's avatar
v-lili6-msft
Community Support
7 years ago

hi, Anonymous 

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

 

Best Regards,

Lin