Report Portal

Using Dax To Handle Multiple Parent Hierarchies

A common accounting task is to consolidate the financial results of subsidiary companies into combined results of a parent company. A parent company can have one or multiple subsidiaries. Each subsidiary can also have one or multiple subsidiaries beneath it. The relationships between parent companies and subsidiaries are often organized in a hierarchical structure.

In a single parent hierarchy, each child node has a single parent. In a multiple parent hierarchy, each child node can have either a single parent or two or more parents. In the single parent hierarchy diagram below, we can see that entities B and C have A as a parent, D and E have B as a parent, and F has C as a parent. The multiple parent hierarchy differs from the single parent hierarchy in that E has both B and C as a parent.

Read more...

 

Tags: dax, tabular

 

2007-2015 VidasSoft Systems Inc.