ISACTIVE() function

The IsActive function is to be used alongside the Start/End functionality within dimensions. When Start/End functionality is switched on for a dimension, each item will have a start or end date.

IsActive will return the value of 1 for all periods between the start and end dates. Otherwise it will return the value 0

For a block which has a dimension which has start/end dates enabled then IsActive() will return 1 or 0 for each of the items in each month based on the start / end dates. See below for the expected result for an indicator formula set to IsActive()

IsActive does not apply to dimensions without start/end dates. Therefore for items on a dimension without start/end dates, we can return 1 for all items

If a block has no dimensions, and IsActive() is used in a formula, we can assume the value is always 1