dax splitting by using measure

[Anonymous]

Hi,

there is a column(GeoLocation) with  (latitude,longitude). how to split latitude and longitude as two differet columns by using only measure.

Thank you

[v-xicai · Accepted solution]

Hi @Anonymous ,

az38's suggestion is great , you can also create measures like DAX below.

Latitude=
var Comma= FIND(",",Table1[GeoLocation],1)
return
MID(Table1[GeoLocation],1,Comma-1)
 
Longitude=
var Comma= FIND(",",Table1[GeoLocation],1)
Var Len=LEN(Table1[GeoLocation])
return
MID(Table1[GeoLocation],Comma+1,Len-Comma)

Best Regards,

Amy

Community Support Team _ Amy

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

[az38]

hi @Anonymous 

it depends on exactly format of your column. show a data example, please

do not hesitate to give a kudo to useful posts and mark solutions as solution

[az38]

@Anonymous 

anyway, try this column

=
VAR V_Pos = FIND(",",[GeoLocation]) 

RETURN
    ROW(
        "Lat",LEFT([GeoLocation],V_Pos-1),
        "Long",RIGHT([GeoLocation],LEN([GeoLocation])-V_Pos)
    )

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn