Forum Discussion

OmarTalk2IoT's avatar
OmarTalk2IoT
Frequent Visitor
7 years ago
Solved

Custom column: Add text to data for different format

Hello,

 

I have 2 variables [Latitude] and [Longitude], and I would like to make a custom column which outputs in the following format: N[Latitude],E[Longitude] with "N" + "," + "E" being text.

 

Thank you in advance,

 

Omar

Talk2IoT

Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Hi OmarTalk2IoT,

     

    The first solution is that you can simply use "&" symbol to concatenate thses columns and symbols in either DAX or Power Query as below:

     

    Result = "N" & [Latitude] & "," & "E" & [Longitude]

     

    Also, the second solution is that you can create a calculate column using DAX below:

     

    Result =
CONCATENATE (
    "N",
    CONCATENATE (
        [Latitude],
        CONCATENATE ( ",", CONCATENATE ( "E", [Longitude] ) )
    )
)

    Regards,

    Jimmy Tao

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Hi OmarTalk2IoT,

     

    The first solution is that you can simply use "&" symbol to concatenate thses columns and symbols in either DAX or Power Query as below:

     

    Result = "N" & [Latitude] & "," & "E" & [Longitude]

     

    Also, the second solution is that you can create a calculate column using DAX below:

     

    Result =
CONCATENATE (
    "N",
    CONCATENATE (
        [Latitude],
        CONCATENATE ( ",", CONCATENATE ( "E", [Longitude] ) )
    )
)

    Regards,

    Jimmy Tao