LEAVES

The LEAVES identifier returns all the leaf node values as an array. It needs to be used with an aggregate function in a calculated row.

Example#

Let's create a calculated row to store the minimum values of the leaf nodes under the "Channel Partners" product segment.

LEAVES identifier

Enterprise planning, Integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co Engineered with Lumel.
BUILT ON