Help With Creating Relationship Among Tables

[Hasan_iba]

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

[v-jiascu-msft]

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

[v-jiascu-msft]

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