Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Just can´t I have both formats with "." and ","