PowerBI Table showing wrong values

[LordSnow]

I have rather a peculiar problem. I have 6 columns in a table. One of the columns is named "Amount". Now this column is misbehaving. This column has values ranging from 100k to 10M. I have imported data from an excel file. some of the rows are showing proper values, while others are not. For eg. row A in excel has 450k and the same row in PowebI shows 450k. Row B in Excel has 350K but powerBi table shows that value as 35M. Please help me solve this issue.

[LordSnow]

@Greg_Deckler Thank you for replying. I was calculating them in power query, but my issue is solved. Thank you again for reaching out.

[Greg_Deckler]

@LordSnow Are there any calculations involved or are you doing a straight import from Excel and this is how the data shows up in the Data view in Power BI?