Bill of materials (BOM) with unlimited number of explosion solved with a recursive function in M Formula Language For Power BI or Excel Power Query
Example with a test table
You can also just invoke the function and return one column for each explosion.
