How to link multiple fact tables in power bi

[vikasmahajan]

Hi Team,

I have following tables I need to create data model using bridge table in power BI need your support for the same. Here is my data set.

Sales:

Year	Month	Branch	Item Number	Customer Number	Invoice Number	Order Number	Salesman Number	Invoice date	Sales Amount	Sales Qty	Cost Amount	Margin Amount	Unit  of Measure
2014	Jan	40	111	231	4567	1	11	01-01-2014	234	25	25	50	Rs
2014	Feb	40	111	232	4568	1	11	02-02-2014	500	30	30	40	Rs
2014	march	40	111	233	4569	1	11	03-03-2014	200	40	40	25	Rs
2013	Jan	40	121	234	4570	1	11	04-01-2013	500	24	24	40	Rs
2014	Feb	40	121	235	4571	1	12	05-01-2014	483	20	20	50	Rs
2012	Mar	41	121	236	4572	1	12	06-01-2012	532.8	23	23	40	Rs
2014	Apr	41	131	237	4573	1	12	07-01-2014	582.6	20	20	25	Rs
2014	May	41	131	238	4574	1	12	08-01-2014	632.4	24	24	40	Rs
2014	Jun	41	131	239	4575	1	13	09-01-2014	682.2	20	20	40	Rs
2014	Jul	41	131	240	4576	1	13	10-01-2014	732	23	23	25	Rs
2014	Aug	42	131	241	4577	1	13	11-01-2014	781.8	20	20	40	Rs
2011	Sep	42	131	242	4578	1	14	12-01-2011	831.6	25	25	50	Rs
2014	Oct	43	141	243	4579	1	14	13-01-2014	881.4	30	30	40	Rs
2010	Nov	43	141	244	4580	1	14	14-01-2010	931.2	40	40	25	Rs

Inventory:

Branch	Item Number	On Hand Qty
40	111	356
41	121	400
42	131	500
43	141	100

Purchasing:

Year	Month	Branch	Item Number	PO Number	Req Delv Date	PO Amount	Ordered Qty
2010	nov	40	111	21	01-01-2010	3000	45
2011	sept	41	121	22	01-01-2011	4000	32
2012	mar	42	131	23	01-01-2012	5000	19
2013	jan	43	141	24	01-01-2013	6000	6
2014	jan	44	151	25	01-01-2014	7000	56
2015	march	45	161	26	01-01-2015	8000	40

My data model should look like this :

[MFelix]

Hi @vikasmahajan ,

For this you can manage the relationships inside Power BI look at the link below:

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships