Excel (BOM) Bill of Material

[willtunechi]

I have the following table that is loaded automatically

I need to somehow create a table that relates the part number and components at all levels, returning the result as below.

 

[ExcelToDAX]

Where are the levels? I think you need to be more specific in your ask

 

[willtunechi]

Where are the levels? I think you need to be more specific in your ask

I basically need to search for all possible components of a given part number.

in the example I sent it shows part number 123 and component nhy.

nhy which is used in 789 which is used in 456 and this used in 123