Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Dear esteemed forum.
This is an ERP structure problem which I am trying to solve.
I have materials, which are structured as multilevel parent/child relationship (Bill of materials).
There are 2 tables with the following relevant columns
T1:
Material
Bill of material
Bill of material Level (0 to X)
T2:
Bill of material Component
Bill of material
Note: All columns are "many" and "Bill of material component" could be blank with established relationship.
Now, T2 BOM component is considered child towards T1 Material, thus, first level of parent-child I can build easily. But, since the levels of Bill of material could be many (10-20 levels), I do not fully understand how to model this in a recursive way. (Preferably something that can be used in a matrix). BOM level is there, sure, but I am not sure how it could be used in this scenario.
If there's anyone out there with a simplistic view to this problem it would be incredibly helpful!
Kind regards,
Horsebaker
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
7 | |
6 |