Draft a Fantasy Football Team with Microsoft Power Query

Fantasy football draft season is here, and the UX test lead for Power Query, Ben Martens, thought that picking his fantasy team seemed like an interesting test case for Power Query. Here it is how he did it in his own words:

There’s a lot of data available and I thought that past performance might give some indicator of future results. Before I could figure that out, I needed to pull all the data into a single table. Here’s a walkthrough of my solution. It’s not short so I might be brief in some areas. MORE