Forum Discussion
Calculating with values linked throughout a child-parent hierarchy
Hi, roelandgeorge
Using flattening in Power Query is indeed one way to handle parenting. In addition, you can also use the DAX function PATH with the Lookupvalue function. You can refer to the following articles to deal with your parent-child calculations:
In this article, we use the two functions mentioned earlier. DAX does not directly support parent-child hierarchies. To get a browsable hierarchy in the data model, you must naturalize the parent-child hierarchy. The following article is another way to deal with parent-child computations:
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Jianpeng, thanks for the response, however using DAX, a simple path does not work immediately because the components are used in different end products so multiple parents. I'm wondering if I can use other formulas.
Hi, roelandgeorge
Thank you very much for your reply. There are currently a limited number of methods and functions for dealing with parenting, and it is recommended that you read the following methods for dealing with the problem and somehow apply them to your data.
Understanding functions for parent-child hierarchies in DAX - DAX | Microsoft Learn
Clever Hierarchy Handling in DAX - SQLBIpowerquery - Dynamically flatten ParentChild Hierarchy using Power Query in PowerBI - Stack Overflow
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
