Split a coordinate column with DAX

[Anonymous]

Hello everybody, how is it going?

I have a question that I need help, please. I checked the other threads but got a different result.

I need to split a coordinates column that latitude and longitude are delimited by a comma, but i cannot use Power Query.

For the longitude, the formula worked perfectly, but for the latitude I got some errors: some values got the divider and others got the divider and the first number from the right.

Latitude formula that I used and didn't worked:

latitude  = LEFT('Tabela KM 2'[COORDENADA], len('Tabela KM 2'[COORDENADA]) - find(",", 'Tabela KM 2'[COORDENADA],,0))

Longitde formula (that worked):

LONGITUDE = RIGHT ('Tabela'[COORDENADA], len('Tabela'[COORDENADA]) - search(",",'Tabela'[COORDENADA],,0))

Sample dataset:

COORDENADA	LATITUDE	LONGITUDE
3.8442639,-51.8310729	3.8442639,-	-51.837152
3.8350949,-51.8331285	3.8350949,-	-51.8331285
2.053552,-50.7928413	2.053552,-5	-50.7928413

Thanks in advance everyone!

[tamerj1 · Accepted solution]

@Anonymous 

Please try

latitude =
VAR String = 'Tabela KM 2'[COORDENADA]
VAR Items =
SUBSTITUTE ( String, ",", "|" )
RETURN
PATHITEM ( Items, 2 )

[Anonymous]

Hi Tamerj1! Thanks for the response!

Your response brought the longitude, but changing the "2" for "1" on the return solved completely my problem.
Much thanks to you!