Forum Discussion

Anonymous's avatar
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])+...
Need Help
Anonymous's avatar
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's avatar
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's avatar
    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 :-(