Forum Discussion

Mad's avatar
Mad
Regular Visitor
5 years ago

Transforming a text value into a number with Power Query

Hi,   I have an issue with Power Query since a few days regarding number formating.   We export a data from Google Adwords in a CSV, then work on the CSV from within Power Query to build our repo...
Need Help
mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

You should be able to add a Replace Values step while it is still text type to do that, before you change to decimal.

 

Pat

 

  • Mad's avatar
    Mad
    Regular Visitor
    5 years ago

    Ok, but now I see that it won't work like this in all cases due to the format ğŸ¤”. I have results originally appearing like this in the CSV: 9783.115.489,02. In Google, I see 97,83€. 

    I suppose it has to do with the regional set up, but can't find any other way to adapt it than by using "change type". It should actually work like this, but for some reason doesn't.