Oscar's avatar
Oscar
Frequent Visitor
9 years ago
Status:
Accepted

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)

Reports

5 Comments

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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's avatar
    Oscar
    Frequent Visitor
    8 years ago

    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's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Oscar

     

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

     

    Best Regards,
    Herbert

Completed Ideas