GETCURRENTRANGE
Last updated
Last updated
The GETCURRENTRANGE funtion returns a range of value based on active period and period selection.
DS.(SERIES).GETCURRENTRANGE()
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
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.
Sales
845
122
561
681
594
842
1153
674
951
154
214
854
Q1 Sales
1528