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.
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!