FIRSTPOPULATEDDESCENDANTVALUE
FIRSTPOPULATEDDESCENDANTVALUE will return the first child with a value for a given consolidation intersection. This function only works at a consolidated level.
js
FIRSTPOPULATEDDESCENDANTVALUE(dimension)Parameters
dimension- The dimension used to identify the first descendant value.
Examples
js
IF(ISLEAF(), CONTINUE, FIRSTPOPULATEDDESCENDANTVALUE("Time"))Note: If this is calculating a N-Level value it will return said value. If this is calculating a consolidation on the Time dimension it will only return the first descendants value.
If you were looking at 2020, this would return the value for 2020 - Feb, if 2020 - Jan was empty.