-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 52-
(Solution in any language also welcome for Power Query Challenges)
We had done a version of this challenge earlier.
Excel Challenge 27 - https://lnkd.in/dTrYaAcD
Column A contains a list of soccer clubs. Let’s say number of clubs is n.
Create the table where each team face each other once only.
A team should appear exactly (n-1)/2 times on one side of the result table in case of odd number of clubs.
In case of even number of clubs, on one side it would appear n/2 times and on other side, it would appear n/2-1 times.
You may not get the same order of teams in your output as shown.
Download Practice File - https://lnkd.in/dn8A5n_r
A file illustrating even number of entries - https://lnkd.in/dDUkjgha
(Post answers in Comment. Your approach need not be different from others as long as you have worked out your approach independently)
#powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #excel, #excelchallenge, #python, #r
Excel BI’s LinkedIn Post