— CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 4 —
Generate the result table as shown.
In case of more than one person in first column, amount will be divided equally among all persons in that row.
Query has to be dynamic to accommodate future months, orders nos, names. No new year will come, so no need to worry about year. Sorting of Months and Name is important.
(Post answers in Comment)
Download Practice File - https://lnkd.in/d7pCtz-v
#powerbi, #powerquery, #dax, #powerquerychallenge, #powerbichallenge, #powerqueryproblem, #powerbideveloper, #powerbidesktop, #powerbitips, #powerbitricks, #excel, #excelchallenge, #excelproblem
Excel BI’s LinkedIn Post