Incorrect values or amounts when loaded in Power Bi from MS Excel.

Hi,Umar_Ahmed I am glad to help you.
Hello,vicky_,thanks for your concern about this issue.

Your answer is excellent! And I would like to share some additional solutions below.
In fact,vicky_ has provided very comprehensive advice, have you solved your problem by troubleshooting already?
Ensure that the data types and formats in Excel are consistent with those in Power BI. For example, check for decimal points, currency symbols, or other formatting.

Have you performed some calculations for data aggregation in Excel? If you have already performed some processing in Excel, such as calculating the sum of salaries of all employees for the month, etc., when you import the data into Power BI Desktop, it is recommended that you reopen these data processing operations by writing DAX in Power BI to avoid incorrect results due to differences between syntaxes.

Please check the relationships between your table models to ensure that there are no duplicate or incorrect relationship connections, as this will change the computational context of the DAX code and cause incorrect results to be returned (even if the DAX code itself is correct).

In conclusion, you need to check the following points:

Are the data types correct.
The code formulas conform to the Power BI syntax specification.
The model relationships used are connected correctly.
Here's a document on troubleshooting the problem that I hope you find helpful.
URL:
Fixing Data Inconsistencies using Power Query Replacement Tables — Ground Floor Analytics
Troubleshoot the connection from Excel to Power BI data - Power BI | Microsoft Learn

If you find a suitable solution, you can share the solution that helped you, or mark the suggestion that helped you in the forum as a solution, which will help other users in the forum.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.