Rounding incorrect when formatting decimal number

[Oscar]

I created a simplified measure as:

Measure = DIVIDE(51, 80)

and I format it (0.6375) as a decimal number with 3 decimals.

Instead of 0.638 the value is rounded down to 0.637 .

This is incorrect (and is does not occur when explicitly using the ROUND() function).

Please fix.

Thanks!

(Power BI Desktop Version: 2.50.4859.502 64-bit (september 2017)

[v-haibl-msft]

@Oscar

I can repro the same issue as you. I’ve reported it internally to Power BI Team: CRI 51094338
I’ll post here once I get any update about it.

Best Regards,
Herbert

[Oscar]

@v-haibl-msft

Hi Herbert,

In all cases that I have tested, formatting the number by using the format button, will result in a correctly rounded number.

0.637 -> 0.64

0.657 -> 0.66

As far as I have seen, the rouding problem only occurs when the fourth decimal is a 5.

Can you confirm this behaviour?

Regards,

Oscar

[v-haibl-msft]

@Oscar

This fix should will be available in Nov 2017 version of PBI Desktop.

Best Regards,
Herbert

[Oscar]

Thanks @v-haibl-msft, that's good news!

Best Regards,

Oscar