Forum Discussion
20941199
Sep 24, 2020Copper Contributor
Issues on power query
Hello everyone, Glad I found this group. I am just 5 weeks into studying an online course in Data Analytics and I really need help with a step I am in. I am using power query editor and created a bl...
SergeiBaklan
Sep 25, 2020Diamond Contributor
I assume default decimal separator for Power Query in your locale is dot. If convert numbers with commas as decimal separator PQ ignores. However, you may select the column, from right click menu select Change Type, next Using locale, next select Data Type as Decimal Number and any locale where comma is the default decimal separator, e.g. Danish. 28,5 will be converted to number 28.5