Daily Shaarli

All links of one day in a single page.

June 3, 2021

Parent/Child Hierarchies in Tabular with Denali - SQLBI

Clearly, the NodeDepth cannot be aggregated using SUM, we need to use MIN. Thus, we define a new measure MinNodeDepth which simply aggregates the NodeDepth column using MIN. The final result, with all these measures in a PivotTable, can be seen here: