Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
jordanwhite16
Regular Visitor

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

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

4 REPLIES 4
Anonymous
Not applicable

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
Super User
Super User

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



Regards,
Sachin
Check out my Blog

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

 

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?

 

 

Attached.png

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.