I need to forecast future need of my BOM parts based on current inventory and future demand. I have a forecast for the main parts. I have a BOM table that tells me each part that is required to build the main parts. I have current inventory of my BOM parts. I need a matrix the has the BOM parts in the rows, month/year in the columns, and my inventory levels in the values. This matrix will tell me what month I will go into a negative inventory value. I have attached a sample pbix file. Thanks for your help.
SampleFile.pbix (60.3 KB)