Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Date Filter - A week from today

Hello everyone, 

 

I have a dashboard that has a tab showing events happening in this week , so I used the filter by date - > Filter Type ( Relative Date ) , Show Items when the value is in this week , however , it shows dates from previous Sunday until Saturday , good enough but not perfect. 

 

Does anyone know a method to make it show a week from today?    For example today is 16.03.2022 , and show all the dates until 23rd.   and to adapt automatically every day. 

 

Photo attached. 

 

 

Thank you ! 

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hello 

     

    I have tried your formula and still couldn't work it out properly .  However ,  I realised how idiot I am , and how easy the solution was,  that's what I wanted : 

     

     

    Thank you for your assist John 

4 Replies

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    4 years ago

    You could add a new column to your Date table and then use that as a filter on the visuals

    In next 7 days = IF( 'Date'[Date] >= TODAY() && 'Date'[Date] < ( TODAY() + 7 ), 1 )
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you John 

       

      I am trying to do what you've advised , however there's something I don't know how to adapt from your formula. Can you please advise ? 

       

       

      • johnt75's avatar
        johnt75
        Icon for Super User rankSuper User
        4 years ago

        You need to give the column a name, so there needs to be something to the left of the = sign. In my example I called the column "In next 7 days", but you could use something more descriptive