Forum Discussion

BarryFletcher's avatar
BarryFletcher
Helper III
2 years ago
Solved

Table rounding up values?

Hi all,

 

I have a power query with a value as shown below....

 

When I import this column / values to my power bi table it is setting all the value below 0 (0.4 etc) as 0 and not totalling them up as required? Even thought he column is set to decimla and 2 decimal places etc?

 

  • Usually after you import data, PQ will change the data type automatically.

     

    you can try to delete the change type step to see if the data is correct.

     

1 Reply

  • Usually after you import data, PQ will change the data type automatically.

     

    you can try to delete the change type step to see if the data is correct.