Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Table in power query keep rounding numbers

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 anyb...
Need Help
  • ronrsnfld's avatar
    ronrsnfld
    4 years ago

    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.

     

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    = 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's avatar
      Vijay_A_Verma
      Most Valuable Professional
      4 years ago

      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's avatar
        Anonymous
        Not applicable
        4 years ago

        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