Multi Level BOM

[jontas7]

Hi,

I've tried to browse the forums to find a suitable solution for my challenge but I do not seem to find what I am looking for.
So I decided to try to explain my challange the see if someone could help me.

I have a BOM-File which is roughly 97 000 rows.
This file holds key information such as
Item Number = Top Item
BOM Id = Unique Number for the BOM
BOM Item Number = Component Item Number

Then of course a bunch of other fields which might be relevant, and it might not.
My challenge is that my BOM Item Number could be present in the Item Number column as well, then holding a few BOM Item Numbers in the BOM ID for that specific Item.
Then this loop could go on for as much as 60 levels down in a structure.

When I try to do this on my own I always end up with having an error message telling me that: "The value xxx has multiple values"
Is someone willing to help me with this task or guide me how to achieve this?
Here is a picture of the database inserted in excel. Please let me know if further information is needed to help.



Thanks in advance!

[ImkeF]

You can try this: http://www.thebiccountant.com/2017/05/08/dynamic-bill-of-material-bom-solution-in-excel-and-powerbi/

 or this: http://www.thebiccountant.com/2017/02/14/dynamically-flatten-parent-child-hierarchies-in-dax-and-pow...

Both methods will work with items with multiple parents. But I've never used it on so many levels, so you might run into performance issues here.

Imke Feldmann

www.TheBIccountant.com -- How to integrate M-code into your solution  -- Check out more PBI- learning resources here

[jontas7]

Thank you, however I have tried this and my only result is the following error message:

"An error occurred in the ‘’ query. Expression.Error: There weren't enough elements in the enumeration to complete the operation.
Details:
List"

Any idea how to proceed from here?