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.
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. |
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 |