Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Rounding incorrect when formatting decimal number

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)

Status: Accepted
Comments
v-haibl-msft
Employee

@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
Frequent Visitor

@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

Vicky_Song
Impactful Individual
Status changed to: Accepted
 
v-haibl-msft
Employee

@Oscar

 

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

 

Best Regards,
Herbert

Oscar
Frequent Visitor

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

 

Best Regards,

Oscar