Forum Discussion

FrancescoSCP's avatar
FrancescoSCP
Helper IV
3 years ago
Solved

Wrong decimals from Excel data

Hi all,

 

i am having trouble reading data from excel file.

Here the data in the excel:

Value column is formatted as a number:

When i load that data to Power BI, i set off aggregations for Month and Customer and Value like this (aggregation with sum and decimal numbers with 15 decimals):

If i create a table the decimals are incorrect:

If we check month 8 on the Excel there are only 2 decimals:

 

Of course, i can do a Round of the number from the Excel and other workarounds, but what's the problem here?

Any advice?

 

Regards,

Francesco

  • Hi FrancescoSCP ,

     

    Because Javascript: Number - JavaScript | MDN (mozilla.org)

     

    The max digits is 15-17 digits, depending on the actual numbers.

     

    This issue has been confirmed as an ICM , the ID is 340010831 . If there is any progress, I will come back and update .

     

    Best regards,

    Yadong Fang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Community Support

    Hi FrancescoSCP ,

     

    Because Javascript: Number - JavaScript | MDN (mozilla.org)

     

    The max digits is 15-17 digits, depending on the actual numbers.

     

    This issue has been confirmed as an ICM , the ID is 340010831 . If there is any progress, I will come back and update .

     

    Best regards,

    Yadong Fang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.