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 anybody know why ? 😄

 

 

 

 

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.

     

6 Replies

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Icon for Most Valuable Professional rankMost 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
        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)?