Forum Discussion

AtchayaP's avatar
AtchayaP
Icon for Helper V rankHelper V
3 years ago

Power query

Importing data from excel to powerbi  there is a column name called cases target in excel it shows sum as as 1780546  But in power query it shows as 1780664  though I changed data type cases  targ...
Need Help
Show and Tell
AtchayaP's avatar
AtchayaP
Icon for Helper V rankHelper V
3 years ago

yes there were decimal point as 1780545.9999999907 after that changed to int and shows as 1780664

DOLEARY85's avatar
DOLEARY85
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Not sure why it has rounded so much, do you have a copy of the PBI file i can take a look at?