Commutative property violation

[travismd]

Maybe I'm crazy, but I don't think PowerBI is processing multiplication and division appropriately, violating the commutative property.  Here is my example - both formulas should produce the same result (100):

1/-(-1)*100

PowerBI result: 0.01
Excel result: 100

100*1/-(-1)

PowerBI result: 100
Excel result: 100

This issue was found when creating a calculated column.  I havent experimented elsewhere.

[Anonymous]

Hi @travismd ,

The order of precedence of operations in DAX formulas is essentially the same as that used by Microsoft Excel, but some Excel operators, such as the percentage operator, are not supported. Range operators are also not supported.

Therefore, when copying and pasting formulas from Excel, be sure to double check the formulas, as some operators or elements in the formulas may not be valid. If there is any doubt about the order in which the operations are performed, it is recommended that you use parentheses to control the order of operations in order to get a definite result.

Best Regards,
Community Support Team _ Caitlyn