Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
horsebaker
Regular Visitor

Creating recursive parent/child relationship

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

 

1 REPLY 1

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.