Forum Discussion
Table in power query keep rounding numbers
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.
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
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.
Thank you so mutch, that help a lot 😄