cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Filter to exclude last 7 days

Hello everyone. 

Right now I am trying to solve one problem in my report pages. Basically I need to see all the results in my Power BI reports but the date filter should exclude last 7 days from current date. Is it possible to add just some simple collumn or I need to re-adjust all the formulas that are used in the tables? 

Thank You in advance. 

1 ACCEPTED SOLUTION
vanessafvg
Super User
Super User

you could create a filter that uses dateadd

 

Less7Days =
DATEADD ( date, -7DAY )





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




View solution in original post

1 REPLY 1
vanessafvg
Super User
Super User

you could create a filter that uses dateadd

 

Less7Days =
DATEADD ( date, -7DAY )





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors