Agregar una columna nueva a partir de una relacion con otra tabla

[jimmy69]

Hola,

Tengo la siguiente tabla llamada "Datos":

Y quiero que consulte en la tabla GPS:

Si el campo "direccion de salida " de la tabla "datos" es igual a "adreça" de la Tabla GPS, quiero agregar el campo "Latitud" en la tabla "datos".

Necesito ayuda,  muchas gracias

[v-huijiey-msft · Accepted solution]

Hi @jimmy69 ,

Please follow these steps:

1. This is the raw data I created. I would appreciate it if you could bring sample data with you the next time you ask a question.

2. Depending on your needs, you can use the Merge Queries in Power Query.

3. Just select the columns where they are the same and click OK.

4. Check the expand icon in the upper right corner and keep the "Latitud" column.

5. Now for the adjusted data.

If you have any other questions please feel free to contact me.

The pbix file is attached.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!