COLUMN_PERIOD

The COLUMN_PERIOD function can be used to select data from a given measure, for a specified 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

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