Hello, I have Latitude column with Decimal type and there are some spaces between the digits. My question is how I can remove the spaces? . I tried trim function which required changing the type from Decimal to Text and when I changed the type I have strange values.
The following explain the case: Thank
|Latitude(Current)||Latitude (After cleaning)|
|32. 56 472||32.56472|
|3 2.1 2 360||32.12360|
Hi @RamiDaoud ,
Is this problem solved?
If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If not, please share us a dummy .pbix file with the same issue. Please remove real data and sensitive information.
Thank you for your comment I modified it based on your comment. However, I recived the following error:
Expression.Error: We cannot convert the value 32.346477999999998 to type Text.
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.