when two foreign keys in same table(Match) referencing primary key in another table( Team)(. Powerpivot)
Results 1 to 2 of 2

Thread: when two foreign keys in same table(Match) referencing primary key in another table( Team)(. Powerpivot)
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2015
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question when two foreign keys in same table(Match) referencing primary key in another table( Team)(. Powerpivot)

    Can I know , how to establish relationship between two tables in PowerPivot.when two foreign keys in same table(Match) referencing primary key in another table( Team).Match ( Match_Id (PK) , Home_Team(FK) , Away_Team(FK) )Team ( Team_ID (PK) , Team_Name )Both Home_Team and Away_Team columns are referencing to Team_ID in Team Table

  2. #2
    MrExcel MVP
    Join Date
    Dec 2014
    Location
    Sydney, Australia
    Posts
    1,179
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: when two foreign keys in same table(Match) referencing primary key in another table( Team)(. Powerpivot)

    I don't really understand your question. A relationship is between 2 tables, one side has a PK and the other has a FK. You just drag the columns to each other in the relationship view and the relationship is created. It is not relevant if there are 2 records in the FK table or not - the relationship is the relationship.
    Matt Allington is a professional Power BI Consultant, Power BI Trainer and Microsoft MVP based in Sydney Australia. Matt is author of the Power BI book Supercharge Power BI and the Power Pivot Book Supercharge Excel.
    What is Power BI?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •