Forum Discussion
Solved
Linking Tables with Multiple Fields
Hello,
I'm trying to build a sports team PowerBI report. My data is modelled as shown below.
Currently my player table is not linked to the match table. My issue is that PlayerID can appear in around 40 fields in the Match table, i.e. in one of 34 positions they can play, whether they have scored etc. I understand that a field can only relate to one other field. I want all player data to be contained in the player table and just the PlayerID used in the match table. Is this possible when I am using it in so many places?
My data source can be seen here
Why not have a position table with
Match id
Position number
Player id
And join to the match and player tables
