NFL Database - help with table formation and connections - database attached

[jordanwhite16]

Hi all,
I have attached the following NFL database I am creating - however I am coming stuck with an issue. In the table you see I want to pull through the corresponding opposition Quarterback "Player 1", "Player 2" etc from the DepthChart table (labeled QB in the position column) when it matches the opposition for the week but can't seem to get my relationships or Dax correct if anyone could be kind enough to take a look.

https://we.tl/t-L0pf9bfEeM

Regards,

Jordan

[Anonymous]

Thanks for the reply from  SachinNandanwar , please allow me to provide another insight:

Hi, @jordanwhite16 

Could you please let us know if  SachinNandanwar’s response resolved your issue? If it did, kindly accept it as the solution.

Due to our security protocols, I am unable to access the link you provided directly. As a result, I cannot ascertain the root cause of your issue or whether it has been resolved. Could you please provide more context or specific details? This would enable me to assist you more effectively!

When uploading a file, please be careful to delete sensitive information.

For questions about uploading data, you can try the following links:

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Solved: How to upload PBI in Community - Microsoft Fabric Community

Best Regards,

Leroy Lu

[SachinNandanwar]

Create a relationship across the Team column in DepthChart with the Team column in Fixtures.

[jordanwhite16]

I think it would need an IF measure formula to calculate something along the lines of if the column 'opposition' in the table 'fixtures' equals the 'team' column in the table 'DepthChart' then display column Player1 in the 'DepthChart' table - but can't quite figure out the work around

[jordanwhite16]

The relationship is in place - but the player 1 column corresponds with the versus column and not the opposition column like I would like it if anyone has a solution for this?