Forum Discussion
Solved
Floating point issue
Hi, I have a table in Excel sheet, column name is Distance, it has decimal number in it. In power query, I want to transform it by first making it integer/whole number and then multiply it with a fa...
The way floating point is handled in Excel, in the same way it has to be handled in PQ as well. The solution is Rounding the number in both apps. You can use Number.Round for this. Your second last step which is Added Custom1, should be this
= Table.AddColumn(#"Changed Type1", "standard", each Number.Round([#"[email protected]"]*2.1,1))You can also run Rounding by using Transform - Rounding - Round as your last step on your last column.
Thanks. I did not think to round the output, instead was seraching for this just not to happen.