Forum Discussion
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
- amitchandakSuper User
FrancescoSCP , Try use # in place of 0 and try
- v-yadongf-msftCommunity 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.