Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

[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...
Need Help
Ahmedx's avatar
Ahmedx
Super User
2 years ago

look at the screenshot and tell me what should be in the D_NAME column?

 

  • Ahmedx's avatar
    Ahmedx
    Super User
    2 years ago

    will that be right?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Ahmedx 

     

    Yes sir,   The answer should be MR TONY SIN

    the logic is lookup from latest row that has D_Name based on same V_ID (License NO) and Same GPS_Date