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
Return value
Returns the first day of the month for the corresponding month, quarter, or year based on the granularity.
Example
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FDpLJ5cAPc84PHwGWqZiW%252Fimage.png%3Falt%3Dmedia%26token%3D2e594117-8973-41f0-aa19-82401b5946c4&width=768&dpr=4&quality=100&sign=95ba9b14&sv=1)
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FwUazyTyS4yJWElWqF6ZJ%252Fyear.png%3Falt%3Dmedia%26token%3D1bd1c46f-a846-4207-b5c4-d780c5afd74f&width=768&dpr=4&quality=100&sign=67e193fd&sv=1)
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FToMexKuqitBN7UGfiYlo%252FQuarter.png%3Falt%3Dmedia%26token%3D1a6bfb9e-078f-483d-b7b1-b373f758f298&width=768&dpr=4&quality=100&sign=c74ee100&sv=1)
2. COLUMN_PERIOD.END
Syntax
Return value
Returns the last day of the month for the corresponding month, quarter, or year based on the granularity.
Example
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252F1FzH6qBJE4yG4uaYqP9r%252Fimage.png%3Falt%3Dmedia%26token%3Dc1c3877c-abc1-46b8-9ba8-24e2d42976ee&width=768&dpr=4&quality=100&sign=7351f0dd&sv=1)
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252F9zC58cSGcMspH4HXm3H6%252FQuarter.png%3Falt%3Dmedia%26token%3D0993d0ff-0ae1-47fa-9550-6f3a4fcf24b4&width=768&dpr=4&quality=100&sign=7955d696&sv=1)
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252F7K17fB4OWhdUeGqkegsG%252Fmonth.png%3Falt%3Dmedia%26token%3D9e181e67-b110-4beb-83cc-100da89f959b&width=768&dpr=4&quality=100&sign=498f6b6e&sv=1)
Last updated