Forum Discussion

Hasan_iba's avatar
Hasan_iba
Helper II
8 years ago

Help With Creating Relationship Among Tables

Hello Power BI expert community. Hope you all are doing great. I am facing a little problem to create relationship among the tables i am working with. Currently there is no relationship and I am unable to create one myself. It will be a great help if you can give advice regarding how I can create relatiionships across the tables I have. Here is the file I am working with. 

https://drive.google.com/file/d/0B0XwYvmbIN12aVRwMmdXNlhXMVk/view?usp=sharing

 

A prompt solution will be highly appreciated. Thanks

Need Help

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Hasan_iba,

     

    Please check this file for details: https://1drv.ms/u/s!ArTqPk2pu-BkgSU2FAfyg2naW2Uo

    1. Create a date table.

    Calendar = CALENDARAUTO()

    2. Create a table of all regions.

    Regions =
DISTINCT (
    UNION (
        VALUES ( Table1[RegionCode] ),
        VALUES ( Table2[RegionCode] ),
        VALUES ( Table3[RegionCode] )
    )
)

    3. Create a table of all segmentations.

    Segmentations =
DISTINCT (
    UNION (
        VALUES ( Table1[Segmentation] ),
        VALUES ( Table2[Segmentation] ),
        VALUES ( Table3[Segmentation] )
    )
)

    4. Establish many 1:* relationships.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Hasan_iba,

     

    Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

     

    Best Regards!
    Dale