Forum Discussion
Anonymous
4 years agoNot applicable
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...
- 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.
ronrsnfld
4 years agoSuper User
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
4 years agoNot applicable
Thank you so mutch, that help a lot 😄