-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 17-
(Excel formulas also welcome)
Generate the output table.
If a date appears consecutively, then it would appear in From and To.
If a date doesn’t appear consecutively, that has to be discarded.
5, 6 and 7the Oct appear consecutively but 12th Oct doesn’t appear consecutively as after 12th, next date is 15th,.
Tasks will be labeled as Task1, Task2…for a person.
Download Practice File - https://lnkd.in/dUQCyQcf
(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