Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |