Forum Discussion

Anonymous

Not applicable

9 years ago

ROUND & SUM issue

Hi, That's might sound lame but I have a problem doing a simple sum on some of my datas ! At first I added a new column on my table with the following DAX formula : = CALCULATE (SUM([price])+...

Community Champion

9 years ago

Anonymous I doub't there would be anything wrong in the way power bi sums it. To troubleshoot it you will have to drill down to lower levels. Can you drill down to month's level and check with sql query on your source. The only thing I can think is why you need to use CALCULATE fuction. For your calculated column you can simply create it as, SUM([price])+SUM([tax]). See if that makes any difference.

Anonymous
Not applicable
9 years ago
ankitpatira : good idea, thanks, I'll try that !

Eric_Zhang : I took the exact same SQL query and apply those modifications on the query editor :

Added Customer --> = Table.AddColumn(#"Changed Type", "TTC", each [prixnet]+[taxe])
Extracted Year --> = Table.TransformColumns(#"Added Custom",{{"datecreation", Date.Year}})
Removed Columns --> = Table.RemoveColumns( lots of columns here ^^)
Grouped Rows --> = Table.Group(#"Removed Columns", {"datecreation"}, {{"SUM_TTC", each List.Sum([TTC]), type number}})
- Anonymous
  Not applicable
  9 years ago
  Hi,
  
  Just a quick update, I did as ankitpatira suggest. I found discrepancy for all months. I export all data for January: same number of rows, same value... except Power BI does not bother to stored useless decimal "0" :
  
  Left SSMS export - Right PowerBI export
  
  So I tried to change the data type in PowerBI : from Decimal Number (Auto) to Fixed Decimal Number (6), still the same wrong amount.
  - Anonymous
    Not applicable
    9 years ago
    So I focused on 1 day only and voila :
    
    Left SSMS - right Power BI
    
    Not cool, from 50.4 million to 51.2 million :-(