Forum Discussion
can we have Any to Text conversion fixed?
As title says, converting from any to text leads to messed up number. In my case it's 287.1 (any) gets converted to 287.100000000000002 (text). Issue exists for more than 5 years already, can we ha...
This is the storage mechanism of floating point numbers inside the computer and cannot be easily modified. Although there is a Decimal type in Power Query that can accurately represent decimals, this type only exists inside the calculation and cannot be represented externally (can be passed to DAX). For your problem, you may try to nest a Decimal.From function outside the number.
Text.From(Decimal.From(0.1+0.2)) & "AAA"