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
Click here to read more about the April 2021 Updates!
May the fourth be with you, join us online!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.