cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
InsHunter
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.

InsHunter_0-1670380876311.png

Created the structure as below in POWER BI

InsHunter_1-1670380968939.png

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.

InsHunter_2-1670381186524.png

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

https://drive.google.com/file/d/11an1tuJt5ColpEHwAe7AR4yjVi180PB7/view?usp=share_link

 

Deeply appreciate your timely help.Thank you.

 

 

 

2 REPLIES 2
v-binbinyu-msft
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

Announcements
Carousel_PBI_Wave1

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.