COLUMN_PERIOD

The COLUMN_PERIOD function can be used to select data from a given measure, for a specified period.

START	Returns the start date of the period
END	Returns the end date of the period

1. COLUMN_PERIOD.START

Syntax

COLUMN_PERIOD.START

Return value

Returns the first day of the month for the corresponding month, quarter, or year based on the granularity.

Example

COLUMN_PERIOD.START
//Returns the start date for a month, quarter, or year

Month level

Year level

Quarter level

2. COLUMN_PERIOD.END

Syntax

COLUMN_PERIOD.END

Return value

Returns the last day of the month for the corresponding month, quarter, or year based on the granularity.

Example

COLUMN_PERIOD.END
//Returns the end date for a month, quarter, or year

Year level

Quarter level

Month level