Forum Discussion
[Power Query] How to fill missing data from above rows based on condition same Date and Same ID
Hello Community, I have query from SQL server that collecting log from gps the data will update every minute. the problem is on column D_Name (Driver Name) some rows data are blanks a...
see my video
Ahmedx ,
The result is correct. Thank you very much. but I dot know How to apply with the actual file. due to it work with advance editor and i dont have exp. on this. Would you mind checking another(actual) file and how to solve the same problem. Thank you in advance.
Sample 2 flie.
Sample2
Best Regards,
JJ
see my video
Thank you I will try follow your step with the actual data. I will update later .
Update I followed your step and it work.
some rows still blank which mean there is no D_Name Data for the whole day so it shown as blank is that correct?
I think so, or show me where to get the data for these lines. if according to ID and date it is the first day.
OK. I think this is fine, Thank you very much