Wrong decimals from Excel data

[FrancescoSCP]

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

[v-yadongf-msft · Accepted solution]

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.

[amitchandak]

@FrancescoSCP , Try use # in place of 0 and try