Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

dax splitting by using measure

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
6 years ago
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.

3 Replies

az38
Community Champion
6 years ago
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
  Community Champion
  6 years ago
  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
v-xicai
Community Support
6 years ago
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.

Related content