Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Ahmedx , thanks for the quick solution.
I need all the missing days for the month.
Also, I added one more user to the solution, giving some errors..

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

post an example and show what result you are expecting

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Ahmedx ,

    Input Data

    Employee IDDateTime InTime Out
    10027-12-202310 AM5 PM
    10031-12-20239 AM7 PM
    20027-12-2029 AM3 PM
    20031-12-20239 AM9 PM


    Output

    Employee IDDateTime InTime Out
    10001-12-2023  
    20001-12-2023  
    10002-12-2023  
    20002-12-2023  
    10003-12-2023  
    20003-12-2023  
    10004-12-2023  
    20004-12-2023  
     ..  
     ..  
    10022-12-2023  
    20022-12-2023  
    10023-12-2023  
    20023-12-2023  
    10024-12-2023  
    20024-12-2023  
    10025-12-2023  
    20025-12-2023  
    10026-12-2023  
    20026-12-2023  
    10027-12-202310 AM5 PM
    20027-12-20239 AM3 PM
    10028-12-2023  
    20028-12-2023  
    10029-12-2023  
    20029-12-2023  
    10030-12-2023  
    20030-12-20239 AM7 PM
    10031-12-20239 AM7 PM
    20031-12-20239 AM9 PM



    • Ahmedx's avatar
      Ahmedx
      Icon for Super User rankSuper User
      2 years ago

      pls try this

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Thank you so much for the effort and support Ahmedx.

        One thing: I removed last year's data and some unwanted fields before grouping, but after expanding the data, last year's data and removed fields are also showing.
        Can you please guide me to learn advanced power-query skills?