-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 11-
(Excel formulas also welcome)
Generate Result table as shown.
The query needs to be dynamic so that if more rows or columns are added, it should give correct output.
For Excel formulas, dynamism is not a requirement, hence they should take the given range only.
Download Practice File - https://lnkd.in/d37fYN2H
(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