---
url: /cube-functions/firstpopulateddescendantvalue.md
description: >-
  FIRSTPOPULATEDDESCENDANTVALUE will return the first child with a value for a
  given consolidation intersection.
---

# 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.