Forum Discussion
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])+...
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?
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 !
Anonymous
Kindly share any findings you get. :smileyhappy: