-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 62-
(Solution in any language also welcome for Power Query Challenges)
List the From Date and To Date for an employee in a row if workday dates are continuous.
Weekend (Sat & Sun) need to be excluded.
Show the Network Days in last column.
Show NA for an employee if no valid workday dates.
Download Practice File - https://lnkd.in/dpDqirTZ
(Post answers in Comment. Your approach need not be different from others as long as you have worked out your approach independently)
#powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #excel, #excelchallenge, #python, #r
Excel BI’s LinkedIn Post