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

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?

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Eric_Zhang,

         

         

        So I guess the issue is me :(

         

        In DB price and tax are Real (cames from a view) but in the source table those are decimal(19,6). Unfortunatly, that measure doesn't work for any others years.

         

        I'll look in other ways to comapre datas and see if I can change the data type in the view.

         

        Thanks for your help !