Data Transformation word to numbers

[OH_Sport]

Hi,

i loaded a gps-file into PowerBI and try to transform the data.
The GPS data of total distance (in meters) and total acceleration load (total number) are initally categorized as text. when i changed to number, the metrics are lost and i got a number withouth comma. I do not know how to change the metrics, that i got the correct number for total distance in meter (it would be for the first line 2898.45... and the secon 4387.57...) neither does the round up / round down work. 

What are steps, which i have to do to achieve my goal?

Oliver

[Greg_Deckler · Accepted solution]

@OH_Sport Only thing I can think of is that your regional settings have something other than "." set for decimal? I know some countries use "," for that. So you are saying that originally Total Distance was 2898.45093 and when you converted it to decimal number that it just ignored the ".". Unable to replicate that in my testing. See attached PBIX below sig. Possibly you could use the convert "from locale" and choose English - US?

[v-junyant-msft · Accepted solution]

Hi @OH_Sport ,

@Greg_Deckler Your response gives everyone a good direction for troubleshooting. Thank you! If I remember correctly, in Belgium, for example, numbers are formatted with a "," for the decimal point.

@OH_Sport Depending on the region, I have tried to reproduce the situation you are facing. Here is my sample data:

My area uses "." as a decimal point, but in the test data I use a comma as a decimal point.
Then I change it into Decimal Nmuber:

The commas are lost.

Right-click the column header and select Using Locale in Change Type.

Here I use Belgium as an example:

And the final output is as below:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler · Accepted solution]

@OH_Sport Only thing I can think of is that your regional settings have something other than "." set for decimal? I know some countries use "," for that. So you are saying that originally Total Distance was 2898.45093 and when you converted it to decimal number that it just ignored the ".". Unable to replicate that in my testing. See attached PBIX below sig. Possibly you could use the convert "from locale" and choose English - US?