Forum Discussion
mansiluthra12
Helper I
Helper IGet selected value from relative date slicer.
I have Relative date slicer and I want to pick what is selected in drop down.
Is it possible?
Example – Suppose slicer have following value following value – I want to pick weeks.
5 Replies
- amitchandak
Super User
mansiluthra12 m You can get the range in var
measure =
var _max = maxx(allselected('Date'),'Date'[Date])
var _min = minx(allselected('Date'),'Date'[Date])return
<code>
mansiluthra12Actually , I dont need the range between the dates , I need to have text what is selected in filter(like days, weeks,years),as based on selection I will be using it in other measure
Hi mansiluthra12 did you find the solution for this.
Please share me the solution if you find any. Looking for your reply.Thanks in advance
Sanjeev
- Dynamic title =var _max = maxx(allselected(dim_calendar),dim_calendar[Date]) + 1var _min = minx(allselected(dim_calendar),dim_calendar[Date])var prefix = IF(_max -1 > TODAY() && _min < TODAY() || _max -1 == _min, "this", IF(_max -1> TODAY(), "next", "last"))var days_diff = DATEDIFF(_min, _max, DAY)var suffix = IF(MOD(YEARFRAC(_min, _max),1) == 0, "year", IF(days_diff >= 7 && MOD(days_diff, 7) == 0, "week", IF(MOD(YEARFRAC(_min, _max)*12,1) == 0, "month", "day")))var date_diff = IF(suffix == "year", DATEDIFF(_min, _max, YEAR), IF(suffix == "month", DATEDIFF(_min, _max, MONTH), IF(suffix == "week", DATEDIFF(_min, _max, WEEK), DATEDIFF(_min, _max, DAY))))var final_text = IF(prefix == "this", prefix & " " & suffix, prefix & " " & ABS(date_diff) & " " & suffix & "s")return "Text " & final_text
