Forum Discussion
Khomotjo
Helper II
Helper IIError : Group By adding additional numbers
Hello Everyone, I am trying to summarise data using group by but for some odd reason it keeps adding addional numbers : This are the original figures : OrderValue 15860 7930 79...
Hi Khomotjo
This issue is caused by how Power BI (Power Query / M) handles floating-point numbers
It's pretty weird that your sum, in string type and not text, so can you first try to replace the type by Fixed decimal number
If it is not working
In power Query,
can you try to replace Sum = List.Sum([OrderValue]) by Sum = Number.Round(List.Sum([OrderValue]), 2)
mdaatifraza5556
Super User
Super UserHi Khomotjo
Are following these steps"
Suppose grouping the Order value by Customer then
If this answers your questions, kindly accept it as a solution and give kudos.