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

     

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