Forum Discussion
Article assembly lists
Hey,
i am facing a problem where i just can't wrap my head around.
I've a list of articles/items and those articles/items have an assembly list with other articles and ressources; ressources = working time to build this article.
The one thing i want to know is the total time needed to build the whole list of articles.
My big problem is that the assembly lists can contain other assembly lists and so on.
I've already managed to get a total of the 'first level', but i just don't know how to get the ressources of assembly lists of the assembly lists and so on...
2 Replies
Philipp101 ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.Sure, let me try:
Project table
Project No P001 P002 P003 P004 Project Task table
Project No Item No Item Description Is Assembly List Quantity P001 1001 Machine01 Yes 2 P001 1002 Holder No 1 P001 1003 Plate 4 x 3 m Yes 2 P001 1004 Plate 5 x 4 m Yes 1 Assembly List table
Parent Item No Item No Item Description Quantity Typ Is Assembly List 1001 2001 Screw 20 Item No 1001 2002 Mainboard 1 Item Yes 1001 2003 Time to build stuff 4 Ressource No > So for Project P001 we need Machine01 2 times.
> 4 h to build 1 Machine01
> that means a total of 8 h for this item
That's the part i got working.
What i am missing is the Mainboard and the time to build it.
It's also possible that Mainboard has other items that are again an item with assembly list...and so on.
