cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
OmarTalk2IoT
Frequent Visitor

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

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

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

View solution in original post

1 REPLY 1
v-yuta-msft
Community Support
Community Support

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

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors