Forum Discussion

LotteLaugesen's avatar
LotteLaugesen
Icon for Helper V rankHelper V
4 years ago
Solved

Dynamic filter depending on another filter

Hi    I would like to have a date filter showing the last 7 or 14 days depending on another filter like this: Is it possible?   BR Lotte
Dynamic filters
  • LotteLaugesen's avatar
    LotteLaugesen
    4 years ago

    I have find a way to solve it 🙂

    Include Date = IF(SELECTEDVALUE(Weeks[Weeks]) = 1 && SELECTEDVALUE(Dim_Calendar[IndexDay]) < 7,1,IF(SELECTEDVALUE(Weeks[Weeks]) = 2 && SELECTEDVALUE(Dim_Calendar[IndexDay]) < 14,1,0))
     
    Where IndexDay is days from today
    and then I just put a filter on Date slicer saying that Include Date should be 1

     
LotteLaugesen's avatar
LotteLaugesen
Icon for Helper V rankHelper V
4 years ago

I have find a way to solve it 🙂

Include Date = IF(SELECTEDVALUE(Weeks[Weeks]) = 1 && SELECTEDVALUE(Dim_Calendar[IndexDay]) < 7,1,IF(SELECTEDVALUE(Weeks[Weeks]) = 2 && SELECTEDVALUE(Dim_Calendar[IndexDay]) < 14,1,0))
 
Where IndexDay is days from today
and then I just put a filter on Date slicer saying that Include Date should be 1