Table in power query keep rounding numbers

[Anonymous]

Hello

I have a problem with my table, for some reason Power query keeps on rounding my numbers. 

as you see i have the number 3437.50 and when i open the editor it round up to 3438.00

does anybody know why ? 😄

[Vijay_A_Verma]

Can you please copy and paste the complete query from formula bar which is shown in the picture?

[Anonymous]

= Table.TransformColumnTypes(#"Omdøbte kolonner",{{"Betalt dato", type date}, {"Indsat Debet1", Currency.Type}, {"Hævet kredit1", Currency.Type}, {"Indtægt #(lf)Kredit ", Currency.Type}})

Hope that will help 😄

[Vijay_A_Verma]

Thanks. This didn't help, in fact. Can you please post your complete query from Advanced Editor (or at least from beginning till the above statement)?

[Anonymous]

Hope its not to big a problem that som of it is in danish.  

Kilde = Excel.CurrentWorkbook(){[Name="Tabel5"]}[Content],

#"Ændret type" = Table.TransformColumnTypes(Kilde,{{"Faktura dato:", type datetime}, {"Forfalden dato:", type datetime}, {"Salg af ydelser #(lf)eller Vidersalg", type text}, {"Kategori", type text}, {"Beskrivelse ", type text}, {"Indtægt #(lf)Kredit ", Int64.Type}, {"Udgift #(lf)Debet ", Int64.Type}, {"Faktura #(lf) Nr. ", Int64.Type}, {"Betalt dato", type any}}),

#"Omdøbte kolonner" = Table.RenameColumns(#"Ændret type",{{"Indsat Debet", "Indsat Debet1"}, {"Hævet kredit", "Hævet kredit1"}}),

#"Ændret type1" = Table.TransformColumnTypes(#"Omdøbte kolonner",{{"Betalt dato", type date}, {"Indsat Debet1", Currency.Type}, {"Hævet kredit1", Currency.Type}, {"Indtægt #(lf)Kredit ", Currency.Type}})
in

[ronrsnfld · Accepted solution]

Your problem is that in your 2nd line of code, you set that column to an Intger type: "{"Indtægt #(lf)Kredit ", Int64.Type}".  In a subsequent line, you set it to Currency.Type, but at that point it is too late.  Either omit or change the data type for that column in your 2nd line.

[Anonymous]

Thank you so mutch, that help a lot 😄