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.

Select from the list of predefined periods when creating a custom measure linked with a date.

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

Did this answer your question?