Parent child

[Rizwan_Hameed]

Hello to every one!

If any one can help me on below error?

[LivioLanzo]

103 has two different parents

[Rizwan_Hameed]

If 103 is used in two different products then, how to resolve this issue...

[LivioLanzo]

It depends on the final result. One possibility could be applying a many-to-many pattern 

[Rizwan_Hameed]

The objective is to know the main parent and the trail of sub parent till final level...the above cas is sample my main sheet has 5000+ lines...it should be noted one item can be used in more than one product and the resultant product can be used in multiple product...

[LivioLanzo]

Ok.. Could you post a sample of your data along with expected results ?

[Rizwan_Hameed]

The Objective here is to get the cost with drill through till last level.

[LivioLanzo]

Hello @Rizwan_Hameed

you can download the pbix file here with an example: https://1drv.ms/u/s!AiiWkkwHZChHjwoe5QLovRJsY6Ze

[Rizwan_Hameed]

@LivioLanzoits very kind of you, thank you for your time, thank you for your example file.....,

I don,t have parent and child node facility in my data....