Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Fabric Team,
We are seeing some inconsistencies when using the ROUNDDOWN function. For example, when creating a measure/calculated column with this hardcoded formula:
On a call with the Fabric support team (ticket #2404220040008712), we tried and found that the same problem exists even when:
Our current workaround is to put a ROUND on the left side of the formula, that seems to overcome the issue.
Lastly, not sure if this will help you investigate, but we noticed that the breaking point is between 1.8 and 1.9. Where if the decimal number is below or equal to 1.8 the formula will work properly, while it will not work if the decimal number is above 1.9, with the following exception: For some reason, 1.99 and 1.9999 works (evaluates to TRUE), but 1.9, 1.999, 1.99999 and beyond do not.
Looking forward to hearing back from you!
Regards,
Felix
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @spindive,
We saw that you opened a support ticket and the ticket engineer has higher access to investigate this issue than the community support engineer, I would like to know more about this ticket, did they inform you that this issue was acknowledged as a bug and reported internally?
Best regards.
Community Support Team_Caitlyn