Forum Discussion

Fcoatis's avatar
Fcoatis
Post 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 Locale", try each {{"Patrimonio", type number}}, "en-US" otherwise {{"Patrimonio", type number}})

 

 

Thanks in advance

 

Need Help

3 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft 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
      Post Patron
      5 years ago

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

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    5 years ago

    Hi,  Fcoatis 

     

    Sorry. Two formatting types can’t exist in the number type field at the same time, the formatting affects the entire field. Only text types can.

     

    Best Regards

    Janey Guo

     

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