Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
8 | |
8 | |
8 | |
6 |
User | Count |
---|---|
14 | |
12 | |
11 | |
9 | |
9 |