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.   ...
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

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