How do I insert missing weekend rows

[Dylan788]

I have an issue where I multiple IDs with the with values showing Monday - Friday however I need to insert the Saturday and Sunday values for all of them. The Saturday and Sunday values should match the previous Friday value. Is there a way to do this? This should be an automatic thing, where every time new data shows up it should automatically update with the Saturday and Sunday values. 

Thanks!

[Anonymous · Accepted solution]

Hi @Dylan788 ,

Try to use fill down in Power Query.

For example, the data on Saturday and Sunday in the sample data are null.

Right-click the column and select fill down.

You need to note that only null can be filled, if it is empty, you need to replace null with null first.

Best Regards,

Stephen Tao

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

[sandeephijam]

please share the sample data lets try and see how we can achive

[Dylan788]

Hi there! I apologize, I've edited the post to include the old table and the new table. The new table has the highlighted rows with the weekend days on it. Keep in mind the Saturday and Sunday values are the same as the Friday values.