-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 16-
(Excel formulas also welcome)
Generate the Result table shown.
Of course, the query should be dynamic i.e. even if number of rows /columns increase or decrease, the Query should give right result on Refresh.
For Excel formulas - Dynamism is not a requirement
Download Practice File - https://lnkd.in/dkmqAJib
(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