-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 32-
(Excel formulas also welcome for Power Query Challenges)
– This is the last problem in the series of FIFA world cup challenges. From tomorrow onwards, we will move to our regular challenges. –
Given are the results for FIFA World Cup 2022 for qualifiers.
You need to align teams to play in Quarterfinals.
Calculate the points in each group and 1st ranked team of Group A will play with 2nd ranked team of Group B. 2nd ranked team of Group A will play with 1st ranked team of Group B.
So, will be the case of C and D, E and F, G and H also.
Ranking in a group will be done by
Criterion 1 - Won - 3 points, Draw - 1 point, Lost - 0 point
Criterion 2 - If points are equal then Goal Difference (GD) which is Goal Faced (GF) - Goal Against (GA) will come into picture. Higher GD means better rank.
Criterion 3 - If GD is also equal, 3rd condition will have to be kicked in…That is more goals scored…Hence, in Group H, South Korea will qualify in place of Uruguay (both tied for second place on the basis of criterion 1 and 2)
Sorting of result is not important here but the combination is. You can sort the result as per your wish.
Download Practice File - https://lnkd.in/d9hRKHSJ
(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