Rounding of numbers

Have a strange thing that is happening when I imported 2 similar files. The one spreadsheet once imported, rounded all the numbers. Made sure on the Power Query Editor the column is set to decimal number (but looks like it is already rounded once imported into PBI) and excel excel format for the 2 spreadsheets is identical, as well as the DAX formula in PBI.

Anyone face a similar issue?

Can you check in the Advanced Editor if the Changed Type step is setting the type to Int64.Type instead of type number for the affected column?

I’m unable to replicate this issue. So if this doesn’t solve it for you - is there something you can share?

Hi @Stuart, did the response provided by @Melissa help you solve your query? If not, how far did you get, and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!