Coversion of whole number values into Latitude and Longitude

[mohsin-raza]

Hi:

The task is to convert the following table values into Latitude and Longitude so that it will work for Azure Map and Filled Map.

can somebody help me to solve this problem?

Regards:

Longitud	Latitud
1513530	6682264
1521082	6688493
1522335	6693740
1517873	6703423
1514922	6689035
1520692	6687986
1521573	6688839

[v-zhangti · Accepted solution]

Hi, @mohsin-raza 

You can try the following methods. Added custom columns in Power Query.

Save and apply to Desktop.

Change the data format for both columns. The result is shown in the figure.

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.