Interesting DAX Challenge - 1 | Cross Join Football Teams for Matches in Power BI
06-12-202205:51 AM
Hello!
In this video, ExcelFort presents its first Power BI DAX challenge. An interesting DAX challenge and the the solution are presented in this video. You can download the source data and completed files to solve the problem yourself and compare my solution to your own or share your alternative solution in the comments section below.
The challenge is to create two tables from a single table having 10 football teams. The first table should show combinations of teams while making sure each team plays two games against every other team. The second table should show each team plays one game against the other.
This is an effective way to improve your DAX knowledge by completing challenges. I always like to learn from others and it has helped me a lot.
