Parent-Child Hierarchies

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

DAX does not directly support parent-child hierarchies. To obtain a browsable hierarchy in the data model, you have to naturalize a parent-child hierarchy. DAX provides specific functions to naturalize a parent-child hierarchy using calculated columns. The complete pattern also includes measures that improve the visualization of ragged hierarchies in Power Pivot.

Read more...

Tags: dax, design

 

2007-2015 VidasSoft Systems Inc.