Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Rounding Off Automatically

I have the following list in power query     When it is exported to the desktop, it is rounded up automatically; even though, the format is decimal.   Any ideas about why this is hap...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous ,Open Data Transformation/Edit Query. Check The data Type there It should number/decimal not int.

     

    Or Right click on the table and open Advance Editor. And Check for this column. This should Number/numeric. Not INT64. If it is int change it to number.

     

    Please keep a backup file, before doing this.

     

     

    To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous ,Open Data Transformation/Edit Query. Check The data Type there It should number/decimal not int.

 

Or Right click on the table and open Advance Editor. And Check for this column. This should Number/numeric. Not INT64. If it is int change it to number.

 

Please keep a backup file, before doing this.

 

 

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    amitchandak Anonymous 

     

    Hi all, I have the same problem with round off the values, however this numbers coming from a measure, column it is in number format as you explain  above. What i am doing wrong?

     

    Thank you in advance