-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 7-
(Excel formulas also welcome)
Generate the result table as shown.
- All week names should appear even if they don’t appear in the source table. In the source table, Thu and Sat are not appearing.
- Even if the person is not allocated on any given day, even then his name should appear. Hector Terry and John Doe are not allocated any day in Source table.
Download Practice File - https://lnkd.in/d-nDaS36
(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