Forum Discussion
Converting Longitude to Decimal data type
Hi there I am importing some longitude and latitude values from a text file. I need to store these as numbers. So my one longitude value is -2.511761 When I try to convert it to a decimal i...
Hey,
check the "Regional Settings" of the current Power BI file:
It's likely, that your seetings do not match the character that is used in your text file.
Hopefully this provides some additional insights.
Regards,
Tom
Hi Anonymous ,
By my tests, I cannot reproduce your issue.
Please check if all of the values for longitude is like -2.511761.
If you still need help, please share a dummy pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Cherry
Hi
Got this sorted by changing regional settings in PB for decimals