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

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

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'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