GETCURRENTRANGE

The GETCURRENTRANGE funtion returns a range of value based on active period and period selection.

Syntax

DS.(SERIES).GETCURRENTRANGE()

Example

Consider the below table that has Sales values for all months in a year. Our objective is to find the Quarter-1 Sales value.

Periods	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Sales	845	122	561	681	594	842	1153	674	951	154	214	854

To get the value of First Quarter sales, we should first set the Value display as Sim.Months and keep Jan to Mar as the Simulation Period. Then give the formula as:

SUM(DS._Sum_of_2023.[Sales].GETCURRENTRANGE())

Change the Sim.Months according to the values you want to achieve. If you want to get Q4 Sales you should set the Sim.Months as Oct to Dec.

Result

Q1 Sales

1528