Forum Discussion

AtchayaP's avatar
AtchayaP
Helper 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
DOLEARY85's avatar
DOLEARY85
Resident Rockstar
3 years ago

Hi,

 

before you changed the data type to int were there any decimal values that have been rounded?

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

AtchayaP's avatar
AtchayaP
Helper 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
    Resident 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?