Forum Discussion
Solved
Error : 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)
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)