Forum Discussion
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.
It has to be specific to the Unit Number though, and sometimes there are many missing values in a row and it is more accurate to use the site from the closest date, rather than the last date.
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