I am trying to make a inventory & procurement report to support my sales forecast.

[sam_nik12345]

I have BOM and forcast data as shown below; I need help in linking forcast to BOM data. I am new to Power BI.

Here is a sample of what BOM and forecast data look like:

plant	id	forecast	material category	component	qty	type	group
x02	item1	item1	cat1	comp1	400.000	xyz	grA
x02	item1		cat2	comp2	0.006	pqr	grB
x02	item1		cat2	comp3	400.000	abc	grC
x02	item1		cat2	comp4	43.104	abc	grD
x02	item1		cat2	dummy	400.000	abc	grD
x02	item1		cat2	comp5	0.140	abc	grE
x02	item1		cat2	comp6	118.000	abc	grF
x02	item1		cat2	comp7	400.000	abc	grG
x02	item2	item2	cat3	comp8	400.000	xyz	grA
x02	item2		cat4	comp1	0.006	pqr	grB
x02	item2		cat4	comp9	0.042	pqr	grH
x02	item2		cat4	comp2	0.028	pqr	grI

forecast	Jan-20	Feb-20	Mar-20	Apr-20	May-20
item1	5	4	2	6	9
item2	6	1	2	3	4

Can this be done with measure/filter?

[v-xiaoyan-msft]

Hi @sam_nik12345 ,

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thanks in advance for your kind cooperation!

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@sam_nik12345 , Unpivot the second table and get a month on rows

https://radacad.com/pivot-and-unpivot-with-power-bi

Create a common item table and analyze the data together 

Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19

Expected output is not clear