-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 27-
(Excel formulas also welcome for Power Query Challenges)
There are 9 clubs and every club has to play with remaining 8 clubs once only.
Pair the clubs with each other so that one team plays with another once only.
A possible solution is shown though you are free to combine them in any other order while keeping in mind that they should play with each other once only.
Don’t hard code this number 9, you should derive this number from the given range.
Download Practice File - https://lnkd.in/dN4sm9YG
(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
Excel Bi’s LinkedIn Post