Relative date filtering is available for date columns at all filter scopes (report, page, and visual) and for slicer visuals. These dynamic filter conditions, such as the last 30 days (relative to the current date) promote both data freshness and query performance since the minimal amount of history required can be retrieved. Additionally, relative date filters can often avoid the need to create custom DAX measures to support specific date filter conditions.

In the following example, five report pages are dedicated to a specific relative date filter condition:

A page-level filter is used for each report page with the following conditions, per the following example:

As of 12/14/2017, the five report pages are filtered to the following date ranges with the Include today option enabled:

• Is in the last 12 months 12/15/2016 through 12/14/2017
• Is in the last 12 weeks 9/22/2017 through 12/14/2017
• Is in this month 12/1/2017 through 12/31/2017
• Is in the next 12 weeks 12/14/2017 through 3/7/2018
• Is In the next 12 months 12/14/2017 through 12/13/2018 

A report design such as this would make it simple for users to analyze immediate, near-term, and longer-term trends and issues. 

Three types of relative date filter conditions can be set—is in the last, in this, and in the next. Each of these filter conditions supports day, week, month, and year intervals. For the in the last and in the next filter conditions, calendar week, month, and year conditions can also be specified. These conditions represent full or completed calendar periods only. For example, as of November 28th, 2017, the last one-calendar month and last one-calendar year would include all dates of October 2017 and all dates of 2016, respectively. The week of 11/19/2017 through 11/25/2017 would represent the last one-calendar week.