cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Hasan_iba Regular Visitor
Regular Visitor

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

2 REPLIES 2
Community Support Team
Community Support Team

Re: Help With Creating Relationship Among Tables

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.

Help With Creating Relationship Among Tables.JPG 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Help With Creating Relationship Among Tables

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.