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

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 :-(

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago

    Anonymous

     

    Could you export the SSMS output for year 2015 into an excel and share it? I'll try to load it into my database and play it with Power BI desktop.

      • Eric_Zhang's avatar
        Eric_Zhang
        Microsoft Employee
        9 years ago

        Anonymous

         

        The sample data works in my test.  I still doubt the data is not loaded correctly in your case, is there any other way to compare the data in database and in Power BI, what is the table definition(data types for price and tax) in database? By the way, except 2015's, does that measure work for other years?