Forum Discussion
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...
pls try this
Ahmedx
Super User
Super UserCan you please share your demo input and expected output!
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 |
Output
| Employee 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 |