Decimal Place Issue

[simonchung]

Hi Buddies, 

It's weird that 4.455 would become 4.45500000000000001, anyone facing such issue as well?

How can it change back to 4.455???

(In my case the data type will keep as any, it won't change to decimal, as the column consist of other data type)

Source: Excel

PowerQuery

Power BI

[v-luwang-msft]

Hi @simonchung ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[simonchung]

Really really thanks for your kindly reply, this issue has not been solved.

I'm busy to doing other task, so I have no time to manage this issue right now. I'm really sorry for this, maybe I'll get back to this issue few weeks later

[v-luwang-msft]

Hi @simonchung ，

I created a test file and tested it and this did not happen, you can try to import my test file and see if it is normal, also are you convenient to provide the excel where you have the problem, remember to delete the confidential data for me to test and check.

After import:

Best Regards

Lucien

[amitchandak]

@simonchung , In DAX, in the column tool, restrict the number of the decimal place. There can difference in decimal number accuracy in tools at the high number of decimal places.

[simonchung]

It doesn't works.
Actually, I wanna treat that field as a text