Not sure if this is possible......BUT

[gilbertgm]

I'm trying to make a fantasy football draft tool. I want to take a ranking system from one page where the players are listed as Patrick Mahomes KC (12) and match them to players already on a team through another website that are listed as Mahomes, Patrick KCC QB. And then remove those already on a team from the rankings. I'm stuck and not sure where to start. HELP!! And thank you!

 

[SpillerBD]

https://powerpivotpro.com/2017/09/the-great-football-project-rides-again-in-power-bi/