Issues on power query

%3CLINGO-SUB%20id%3D%22lingo-sub-1711664%22%20slang%3D%22en-US%22%3EIssues%20on%20power%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1711664%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3EGlad%20I%20found%20this%20group.%20I%20am%20just%205%20weeks%20into%20studying%20an%20online%20course%20in%20Data%20Analytics%20and%20I%20really%20need%20help%20with%20a%20step%20I%20am%20in.%20I%20am%20using%20power%20query%20editor%20and%20created%20a%20blank%20query%20of%20one%20of%20the%20variables%20which%20I%20pulled%20out%20of%20a%20source%20data.%20A%20few%20of%20these%20variables%20have%20decimal%20points(.)%20and%20I%20have%20replaced%20them%20with%20comma's(%2C).%20I%20could%20only%20do%20this%20if%20I%20chose%20the%20Text%20type%20data%20type.%20After%20the%20conversion%2C%20I%20chose%20the%20Decimal%20number%20data%20type%20that%20they%20were%20meant%20to%20be%20in.%20Lo%20and%20behold%2C%20all%20of%20the%20variables%20with%20accepted%20comma's%20became%20whole%20numbers%20i.e%2028%2C5%20became%20285.%20Please%20how%20do%20I%20resolve%20this%3F%3C%2FP%3E%3CP%3EI%20tried%20to%20be%20smart%20and%20continued%20solving%20for%20a%20z-test%20choosing%20same%20column%20as%20my%20input%20values%20but%20got%20the%20below%20message.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%2220941199_0-1601010260712.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F222011i1DD92A56CCEE38DC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%2220941199_0-1601010260712.png%22%20alt%3D%2220941199_0-1601010260712.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI'll%20be%20glad%20if%20anyone%20can%20help.%20Thanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1711664%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1713018%22%20slang%3D%22en-US%22%3ERe%3A%20Issues%20on%20power%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1713018%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F808515%22%20target%3D%22_blank%22%3E%4020941199%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20assume%20default%20decimal%20separator%20for%20Power%20Query%20in%20your%20locale%20is%20dot.%20If%20convert%20numbers%20with%20commas%20as%20decimal%20separator%20PQ%20ignores.%20However%2C%20you%20may%20select%20the%20column%2C%20from%20right%20click%20menu%20select%20Change%20Type%2C%20next%20Using%20locale%2C%20next%20select%20Data%20Type%20as%20Decimal%20Number%20and%20any%20locale%20where%20comma%20is%20the%20default%20decimal%20separator%2C%20e.g.%20Danish.%2028%2C5%20will%20be%20converted%20to%20number%2028.5%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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 blank query of one of the variables which I pulled out of a source data. A few of these variables have decimal points(.) and I have replaced them with comma's(,). I could only do this if I chose the Text type data type. After the conversion, I chose the Decimal number data type that they were meant to be in. Lo and behold, all of the variables with accepted comma's became whole numbers i.e 28,5 became 285. Please how do I resolve this?

I tried to be smart and continued solving for a z-test choosing same column as my input values but got the below message.

20941199_0-1601010260712.png

I'll be glad if anyone can help. Thanks in advance.

1 Reply
Highlighted

@20941199 

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