Linking Tables with Multiple Fields

[MBates237]

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

https://docs.google.com/spreadsheets/d/1iJOASe4Kjx8otXUQos_ORc8gajZU1sS1/edit?usp=drivesdk&ouid=1119...

[Deku · Accepted solution]

Why not have a position table with 

Match id

Position number

Player id

And join to the match and player tables

[MBates237]

Oh, I didn't get this at first but now I think I do.

I can have a position dimension table and then a squad/lineup table with playerID, matchID, positionID

[Deku]

Exactly