Forum Discussion
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 happening.
Regards,
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.
3 Replies
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 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
Anonymous Change the data type to decimal number in the power query window like below
You can refer to below links as well
