Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Establishing multiple table relationships

Hi, I wanted to know how to build multiple relationships between tables. I have the following: - Date table - Population table (which includes a unique ID and date field, plus other columns) ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous

     

    If you split tables before import data into Power BI, please ingore the words below.

     

    How do you split one table to many tables, do you use Edit Queries or create a New table(Home ->New Table) with DAX?

    If you use create a New table with DAX, please note the circle dependence problem.

     

    please read this article to learn how to create relationship among tables

     

    1. Date table

    2.Population table

    linked column: [date]

    cardinality: one to many 

    cross filter direction: both

     

    1.Date table

    2.Media table

    linked column: [date]

    cardinality: one to many

    cross filter direction: both

     

    1.Population table

    2.Media table

    linked column: [unique id]

    cardinality: one to one

    cross filter direction: both

     

     

    Best Regards

    Maggie

     

     

     

     

richbenmintz's avatar
richbenmintz
Resident Rockstar
7 years ago

Hi Anonymous,

 

The first part of your ask seems pretty straight forward connect the Date Table to the Population and Media Tables through a 1->* relationships, this will allow you to filter both tables with a single date. The second part is more ambigious, how are the uniqueids related, is media child of population or vice versa, are the uniqueIds related to another seperate dimension? 

 

Are you able to provide a sample file or some sample data?

 

Thanks,

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi richbenmintz,

     

    Thanks for replying so quickly. I'm afraid I can't share any files, but I can hopefully add something further. The data is coming from a survey; the unqiue ID gives a reference for each respondent / row of data, as we wanted to break the survey up into a series of smaller tables to make navigation and use of the dashboards easier. We've therefore got the unique ID as a common link between all of the tables. So, population is one 'cut' of data from the survey; media is another cut, and so on.

     

    Hope this helps.

     

    Best

     

    Chris