Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Slider automatic select the latest values

 

Hi everyone 

 

I need help to make my Slider automatic after a week changes. Im not sure this is possible?

I want my slider to select the last 6 weeks including the current week. 

 

Note: I have a filter that filtre WeekOffSetNum less or equal to 0.

 

 

This is the current code for the column that I use to create this silder

 

WeekOffSet =
IF(
    ISBLANK(
                  WEEKNUM(Dim_Date[Date],2) = WEEKNUM(TODAY(),2) && YEAR(Dim_Date[Date]) = YEAR(TODAY())),
                   "Week " & WEEKNUM(TODAY(),2) - ( WEEKNUM(TODAY(),2) - WEEKNUM(Dim_Date[Date],2)-1 & ""),
           If (WEEKNUM(Dim_Date[Date],2) = WEEKNUM(TODAY(),2) && YEAR(Dim_Date[Date]) = YEAR(TODAY()), "Current Week",
           "Week " & WEEKNUM(TODAY(),2)-( WEEKNUM(TODAY(),2) - WEEKNUM(Dim_Date[Date],2) & ""))
 
Thanks you very much.

 

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , No that is not possible as of now, You have to create a current week like an option for the last 6 weeks. means all 6 week will have same static name