Forum Discussion
Anonymous
2 years agoNot applicable
Add rows with missing dates in Power Query
Good morning, I need to add the missing dates to the attendance list for each employee. I have below information in my table Employee ID Month-Year, Date, Time in and Time Out Thank you all...
- 2 years ago
pls try this
Ahmedx
2 years agoSuper User
Can you please share your demo input and expected output!
- Anonymous2 years agoNot applicable
Hi Ahmedx ,
Input Data
Employee ID Date Time In Time Out 100 27-12-2023 10 AM 5 PM 100 31-12-2023 9 AM 7 PM 200 27-12-202 9 AM 3 PM 200 31-12-2023 9 AM 9 PM
OutputEmployee ID Date Time In Time Out 100 01-12-2023 200 01-12-2023 100 02-12-2023 200 02-12-2023 100 03-12-2023 200 03-12-2023 100 04-12-2023 200 04-12-2023 .. .. 100 22-12-2023 200 22-12-2023 100 23-12-2023 200 23-12-2023 100 24-12-2023 200 24-12-2023 100 25-12-2023 200 25-12-2023 100 26-12-2023 200 26-12-2023 100 27-12-2023 10 AM 5 PM 200 27-12-2023 9 AM 3 PM 100 28-12-2023 200 28-12-2023 100 29-12-2023 200 29-12-2023 100 30-12-2023 200 30-12-2023 9 AM 7 PM 100 31-12-2023 9 AM 7 PM 200 31-12-2023 9 AM 9 PM - Anonymous2 years agoNot applicable
Input Data
Employee ID Date Time In Time Out 100 27-12-2023 10 AM 5 PM 100 31-12-2023 9 AM 7 PM 200 27-12-202 9 AM 3 PM 200 31-12-2023 9 AM 9 PM
OutputEmployee ID Date Time In Time Out 100 01-12-2023 200 01-12-2023 100 02-12-2023 200 02-12-2023 100 03-12-2023 200 03-12-2023 100 04-12-2023 200 04-12-2023 .. .. 100 22-12-2023 200 22-12-2023 100 23-12-2023 200 23-12-2023 100 24-12-2023 200 24-12-2023 100 25-12-2023 200 25-12-2023 100 26-12-2023 200 26-12-2023 100 27-12-2023 10 AM 5 PM 200 27-12-2023 9 AM 3 PM 100 28-12-2023 200 28-12-2023 100 29-12-2023 200 29-12-2023 100 30-12-2023 200 30-12-2023 9 AM 7 PM 100 31-12-2023 9 AM 7 PM 200 31-12-2023 9 AM 9 PM