Forum Discussion

Fcoatis's avatar
Fcoatis
Icon for Post Patron rankPost Patron
5 years ago

try otherwise inside Table.TransformColumnTypes

Ok, here is what I´m trying: Change the type number with Locale settings if I got error keep the local number type:   Something like:   = Table.TransformColumnTypes(#"Changed Type with Loc...
Need Help
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Is the difference between the numbers the presence of "," or "." in the number?  If so, you could just Replace Values ahead of the data type change to avoid the error.

Pat

 

  • Fcoatis's avatar
    Fcoatis
    Icon for Post Patron rankPost Patron
    5 years ago

    Just can´t I have both formats with "." and ","