Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Add missing rows with missing date and time in Power Query

Hello everyone,   I need your help please, I have a table with several IDs and for each ID, I have several dates and timestamp and values, normally, I should have for each ID -rows for each hour, b...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  Anonymous ,

    Here are the steps you can follow：

    1. Create a datetable.

    2. Copy -- Table.

    Select [Date] and [Value] – Remove Columns.

    Select [ID] – Remove Rows – Remove Duplicates.

    3. Add Column – Custom Column – Enter Date table name “Date”.

    4. Home – Merge Queries -- Merge Queries.

    5. Select [Table] – [Value].

    Select [Table.Value] – Fill Down

    6. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  Anonymous ,

Here are the steps you can follow：

1. Create a datetable.

2. Copy -- Table.

Select [Date] and [Value] – Remove Columns.

Select [ID] – Remove Rows – Remove Duplicates.

3. Add Column – Custom Column – Enter Date table name “Date”.

4. Home – Merge Queries -- Merge Queries.

5. Select [Table] – [Value].

Select [Table.Value] – Fill Down

6. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly