How to replicate this macro in Power Query to fill in missing date using nearest dates?

Then you will have to do add a custom column referring to the unit number above. My video here shows how to reference a previous line. https://youtu.be/xN2IRXQ2CvI

Hi justlogmein ,

From my understanding, do you want to group by Unit Number and fill down?

Here's my solution.

1.Group by Unit Number, select All Rows in the opreation.

2.Add a custom column to fill down.

3.Remove the unneeded column and expand the Custom column.

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.