Forum Discussion
nok
Advocate II
Advocate IIProblem with comma in my decimal column
Hello,
I want to change my "Value" column to decimal type, but when I do this, Power BI ignores commas and assumes it is one large combined number.
How my column originally appears in Power Query:
How it looks when I change it to decimal type:
How can I fix this issue using Power Query?
delete the 'changed type' step. Use Change Type (using Locale) which you can reach by right-clicking on the column header
2 Replies
- AlexisOlson
Super User
Use an appropirate culture option on the Table.TransformColumnTypes step.
For example, including the "fr-FR" argument should do what you need.
= Table.TransformColumnTypes(Source, {{"Value", type number}}, "fr-FR") - HotChilli
Community Champion
delete the 'changed type' step. Use Change Type (using Locale) which you can reach by right-clicking on the column header
