Power Query: Comparison of 18-digit ints yields wrong result

[henrikj]

When comparing two 18 digit ints, it's possible to get a true result even when the digits are different. 

Example: 2362747255796852672 is equal to 2362747255796852700. I can vary the numbers a bit and still get the same result, e.g. adding multiple zeros to both numbers, varying the three last digits somewhat.

[v-yanjiang-msft]

Hi @henrikj ,

Because it treats both the numbers as 2.36275E+18, it's by design for a number format.

As a workaroud, you can modify the formula to:

if Text.From(2362747255796852672) = Text.From(2362747255796852700) then 1 else 0

Best regards,

Community Support Team_yanjiang