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
v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity 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.