Quickly and easily set a dynamic range of dates to filter your results.
The same list is used across our Custom Measures filters, in the workbook with measures, and the chart filters in the property panel.
To access predefined periods in the properties panel, first add a date field in the Filter tab, then select "Date range". Once selected, predefined date ranges are aavailable.
The options include the most commonly used periods, and they're listed by the most frequently used.
Predefined periods | Description |
Current YTD (Year to date) | All the dates for this year up to today |
Current MTD (Month to date) | All the dates for this month up to today |
Current QTD (Quarter to date) | All the dates for this quarter up to today |
Current week to date | All the days of the week up to today |
Previous YTD | All the days in the last year up to the same day of this year. Use to compare this year with last year's same time period. |
Previous MTD | All the days in the last month up to the same month this year. |
Previous QTD | All the days in the last quarter up to the same quarter this year. |
Previous week to date | All the days in the week up to the same week this year. |
YTD | All the days in any year up to the same day of this year. |
MTD (Month to date) | All the days in any month up to the same day of this month. |
Last 12 months | Last 12 months |
Last 90 days | Last 90 days |
Last 30 days | Last 30 days |
Last 7 days | Last 7 days |
Previous year | The whole of last year |
Previous month | The whole of last month |
Previous quarter | The whole of last quarter |
Previous week | The whole of last week |
Today | The whole day |
Yesterday | The whole of yesterday |
Max Date | The last date in the field is calculated after each filter and is dynamic. |
Min Date | The first date in the field is calculated after each filter and is dynamic. |