Solved: Filter to exclude last 7 days

Anonymous · ‎07-24-2019

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.

vanessafvg · ‎07-24-2019

you could create a filter that uses dateadd

Less7Days =
DATEADD ( date, -7, DAY )

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

vanessafvg · ‎07-24-2019

you could create a filter that uses dateadd

Less7Days =
DATEADD ( date, -7, DAY )

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!

Filter to exclude last 7 days

Helpful resources

Power BI Monthly Update - November 2023

Fabric Community News unified experience

The largest Power BI and Fabric virtual conference

How to Get Your Question Answered Quickly