Forum Discussion

vikasomahajan's avatar
vikasomahajan
Frequent Visitor
2 years ago

How to develop model attached in post

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 Custome...
Need Help
rajendraongole1's avatar
rajendraongole1
Super User
2 years ago

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!!