Forum Discussion

Per-Erik's avatar
Per-Erik
Frequent Visitor
7 years ago
Solved

Convert between different coordinate map system

 
Hi all!
 
I need your help. I have a database where we in two columns store map-data from users.
 
The map uses the swedish geodetic reference system Sweref 99 - (Swedish reference frame 1999) is a Swedish geodetic reference system used as a reference for various coordinate data in measurement and map production, in databases and more. The reference system forms the Swedish part of the European reference system cooperation EUREF. The system is a realization of ETRS89
 
You see the difference between the two coordinate system in picture below:
 WGS84 and Sweref99
 
Power BI visual map uses the WGS84 standard for maps.
To make it possible to use our map data (sweref99 1330) in power bi, I need to find a way to convert our map data to the format wgs84.
 
I wish I would find dax formula or similar to convert the data to the correct format. Does anyone on this forum have done anything similar and manage to solve a similar problem?
 
Many thanks in advance. /Per-Erik