DAX function that allows you to convert sexagesimal to decimal

[Anonymous]

I'm having trouble creating a new column that allows me to convert the latitude column that is in sexagesimal to decimal.

someone can help me please, I would earn heaven.

[OwenAuger · Accepted solution]

Hi @Anonymous 

I would recommend handling this further upstream (data source or Power Query).

However, here is a DAX expression you could use for a calculated column:

Latitud Decimal =
VAR DMS = [Latitud Fin] // Ideally prefix with table name e.g YourTable[Latitud Fin]
VAR DMS_Delimited =
    SUBSTITUTE ( SUBSTITUTE ( SUBSTITUTE ( DMS, "°", "|" ), "'", "|" ), """", "" )
VAR Grados =
    VALUE ( PATHITEM ( DMS_Delimited, 1 ) )
VAR Minutos =
    VALUE ( PATHITEM ( DMS_Delimited, 2 ) )
VAR Segundos =
    VALUE ( PATHITEM ( DMS_Delimited, 3 ) )
VAR Result = Grados + Minutos / 60 + Segundos / 3600
RETURN
    Result

This changes the delimiters to vertical bars, which allow for convenient splitting of the string with the PATHITEM function.

Regards

[Anonymous]

infinitely grateful 🤜🤛