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.

     

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
Icon for Most Valuable Professional rankMost 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

    • ronrsnfld's avatar
      ronrsnfld
      Icon for Super User rankSuper User
      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.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Thank you so mutch, that help a lot 😄