Forum Discussion
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...
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.
ronrsnfld
Super User
Super UserYour 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 😄