-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 15-
(Excel formulas also welcome)
Generate Top 3 students in all subjects.
The order of subjects in Result table should be sorted alphabetically. (In this picture, you can see only one subject. Output in Excel has all subjects)
There are no duplicates in marks in this problem for a particular subject.
Of course, the query should be dynamic. Adding a new subject or deleting a new subject should give right result.
For Excel formulas - Dynamism is not a requirement
Download Practice File - https://lnkd.in/dnukFd9K
(Post answers in Comment. Your approach need not be different from others as long as you have worked out your approach independently)
#powerbi, #powerquery, #dax, #powerquerychallenge, #powerbichallenge, #powerqueryproblem, #powerbideveloper, #powerbidesktop, #powerbitips, #powerbitricks, #excel, #excelchallenge, #excelproblem, #powerpivot
Excel BI’s LinkedIn Post