Showing results for 
Search instead for 
Did you mean: 
Advocate I
Advocate I

Solution for reconciliation of data at Node levels - Hierarchial data set

Hi, Being a Newbie requesting suitable solution and a suitable viz for presenting hierarchial data analysis.
Source data set sample as below.


Created the structure as below in POWER BI


Now request help to arrive at an analysis format like below which shall help to find the variance at all Nodes which are Parent/Grand Parent/Great grand parent (except only child nodes) like a drill down to each child level where the aggregation happens.


Prepared the data set with calculated columns as per enclosed PBIX file and struck there to proceed further.


Deeply appreciate your timely help.Thank you.




Community Support
Community Support

Hi @InsHunter ,

I'm a little confused about your needs, Could you please explain them further? 

Thanks for your efforts & time in advance.


Best regards,
Community Support Team_Binbin Yu

Thanks for your response.

Objective of this excercise is to reconcile the data under 'Values' column. The data capturing points are child nodes which can be either only a child or may be a parent (for the next level)  as well as child. The realtime data is captured at all nodes and parent node data need to be equal to aggregated child node data. In Practical situation this may not match and thro reconcilation to find the loss intensityand quantify the same against all Parent nodes.Hope i could make some clarity by the above statements.

Best regards,

Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.