Calculating through a hierarcy

[Anonymous]

Hi All

I have two tables with production informations. One table with the Main item, bomlist ID and hours and another table with the items that goes in to the bom list and hours.

The Main items might go in to another Main Item which means that it will be a sub item on a bom list for a main item.

I what to calculate how many hours an Item takes to produce through the whole network of 10 levels.

It means that one item might have a bomlist containing items that have another bomlist containing other items ect.

How can this be done with DAX?

[Anonymous]

An example is here - Item 120000000007 has BOMID 61381008501 which contains sub item 120000000025 and 120000000038. But the last item (120000000038) does also has a BOMID which is D120000000038. This BOMID contains sub item 130007000034 and 160007100193.

So I will like to sum up the hours from the lowest level and up to top level. In the real life case I have 10 levels. In this sample there are only 3 levels.

see sample here:

https://skioldgroup-my.sharepoint.com/:x:/g/personal/jen_skiold_com/EeCnaMOLxKFMkJHlKVGQRz8BFGheMYvr...

[Fowmy]

@Anonymous 

Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?

_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn

[Anonymous]

Hi Foumy,

I have tried to make a sample and description - Hope this help?