— CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 3 —
(Excel formulas also welcome)
Generate the result table from Alphabets table. There is a header row as well, as shown in orange color in the output table. Hence, all values + Header row.
For PQ (not for Excel formulas) - Make sure that query is dynamic i.e. if number of rows and columns increase/decrease, the query should give right result.
(Post answers in Comment)
Note - There is an error in output shown in picture which has been corrected in the practice file below. (Picture update not allowed in Linkedin)
Download Practice File - https://lnkd.in/dAWWUSzv
#powerbi, #powerquery, #dax, #powerquerychallenge, #powerbichallenge, #powerqueryproblem, #powerbideveloper, #powerbidesktop, #powerbitips, #powerbitricks, #excel, #excelchallenge, #excelproblem
Excel BI’s LinkedIn Post