I can't figure out why 0 doesn't equal 0 in some cases.

[mgiusto]

I created a two columns in Power Query, one is named Difference which subtracts one value from another to show the difference.

The other is named Matching and that checks Difference to see if the value is 0, if it is the values of Matching should be "Match" if not "No Match".  When I use the Matching field in a slicer and select "No Match" I will see some values of 0.00 in the Difference column appear, why would this occur and how can I correct it?

Difference = [InvoiceAmt]-[D365.InvoiceAmt]

Matching = if [Difference] = 0 then "Match" else "No Match"

Thank you for any assistance

[mgiusto]

Thank you ImkeF,

I actually did this while waiting for a reply. I did a round to 2 decimal places and that fixed this issue!

[AlexisOlson]

For dollar value columns,  you probably want to use a Fixed Decimal Number data type. This should make rounding errors less common since it isn't using floating point math.

[ImkeF · Accepted solution]

Hi @mgiusto ,
I would recommend to apply a rounding with no decimals to your "Difference"-column.