GETCOLBETWEENPERIODS

The GETCOLBETWEENPERIODS function can be used to select data from a given measure, for a specified period. It should be used with an aggregate function like SUM or AVERAGE.

Syntax#

GETCOLBETWEENPERIODS(fromDate, toDate, measures)

Arguments#

fromDate– The starting period from when data is to be fetched. Required.

toDate– The end period till when data is to be fetched. Required.

measures - Specify the measures for which to fetch data. Leaf-level measures will be taken if measures are not explicitly specified. Optional.

Return value#

Range of data.

Example#

GETCOLBETWEENPERIODS(DATE.ADDMONTH(-6), DATE.ADDMONTH(2), [[Profit]])
//Returns the profit measure for specified the date range