Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Difference in excel data and power bi data

Hi Team,   I have taken a sample database "Superstore" tried to import via power bi and have a table visualisation for sales and year as below    im not sure what is wrong i tired check...
Need Help
  • negi007's avatar
    negi007
    6 years ago

    Anonymous Total will be same. But values under year is different due to using incorrect date field. 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Does your date has a timestamp.  Are you joining it with date table in power bi if so make sure there is no timestamp

 

date = [order date].date

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.