This is an example of the new powerful and flexible tools available in Power Excel.
Excel crunches 206,000 English League football results, showing the output via a Power BI report.
Power query was used to clean and join the tens of thousands of results . We used the new DAX language to create over 20 measures to help us analyse all the results.
Page 1 shows 1 to 1 performance for every team who has ever played in the English leagues since 1888.
The report on page 2 gives every teams’ performance against every other team , with accumulative goals scored for and against , draws, % of wins, draws etc. How has your team done over the decades .We hope you enjoy it.