Bill of Materials DAX (M power query) pattern
This is not yet available on the DAX patterns website, but solutions using M queries have been made by Imke Feldmann (The BIccountant):
- Bill of Materials (BOM) solution in Excel and PowerBI
- Parent-Child Hierarchies with multiple parents in Power BI with Power Query