-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 19-
(Excel formulas also welcome for Power Query Challenges)
Generate Top 3 students in all subjects.
The order of subjects in Result table should be same as in source table.
In case of duplicates, show the names in one cell below the other
Of course, the query should be dynamic i.e. Adding a new subject or deleting a new subject should give right result.
Dynamism is not a requirement for Excel formula solutions.
Download Practice File - https://lnkd.in/drhHmiar
(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