How to develop model attached in post

[vikasomahajan]

Hi Team,

I need to design attached data model in power BI attaching sample data here. Any one assist me how to create same in power BI.

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	1/1/2014	234	25	25	50	Rs
2014	Feb	40	111	232	4568	1	11	2/2/2014	500	30	30	40	Rs
2014	march	40	111	233	4569	1	11	3/3/2014	200	40	40	25	Rs
2013	Jan	40	121	234	4570	1	11	1/4/2013	500	24	24	40	Rs
2014	Feb	40	121	235	4571	1	12	1/5/2014	483	20	20	50	Rs
2012	Mar	41	121	236	4572	1	12	1/6/2012	532.8	23	23	40	Rs
2014	Apr	41	131	237	4573	1	12	1/7/2014	582.6	20	20	25	Rs
2014	May	41	131	238	4574	1	12	1/8/2014	632.4	24	24	40	Rs
2014	Jun	41	131	239	4575	1	13	1/9/2014	682.2	20	20	40	Rs
2014	Jul	41	131	240	4576	1	13	1/10/2014	732	23	23	25	Rs
2014	Aug	42	131	241	4577	1	13	1/11/2014	781.8	20	20	40	Rs
2011	Sep	42	131	242	4578	1	14	1/12/2011	831.6	25	25	50	Rs
2014	Oct	43	141	243	4579	1	14	1/13/2014	881.4	30	30	40	Rs
2010	Nov	43	141	244	4580	1	14	1/14/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	1/1/2010	3000	45
2011	sept	41	121	22	1/1/2011	4000	32
2012	mar	42	131	23	1/1/2012	5000	19
2013	jan	43	141	24	1/1/2013	6000	6
2014	jan	44	151	25	1/1/2014	7000	56
2015	march	45	161	26	1/1/2015	8000	40

Thanks in advance.

Vikas

[vikasomahajan]

Let me check thank you for your response 

[rajendraongole1]

Hi @vikasomahajan - I have create a calculated table that serves as a central link between these three tables

Create a calculated table as below:

Linked Table =

SUMMARIZE(

    UNION(

        SELECTCOLUMNS(

            Saless,

            "Branch", Saless[Branch],

            "Item Number", Saless[Item Number]

        ),

        SELECTCOLUMNS(

            iNVE,

            "Branch", iNVE[Branch],

            "Item Number", iNVE[Item Number]

        ),

        SELECTCOLUMNS(

            Purchas,

            "Branch", Purchas[Branch],

            "Item Number", Purchas[Item Number]

        )

    ),

    [Branch],

    [Item Number]

)

Hope it works

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!