Difference in excel data and power bi data

[Anonymous]

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 checking the Sales column datatype everything seems normal.

Can you all please provide me any suggestion what could go wrong

[amitchandak]

@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.

[negi007]

@Anonymous  can you pl share your excel data file. it is possible that date field and data field from different tables are being used in excel and powerbi report. Once you share data then will assist you.

[Anonymous]

@negi007this is the link from where i downloaded the excel report name (Sample - Superstore Sales (Excel) for Tableau 8.x versions) https://www.wisdomaxis.com/technology/software/data/for-reports/super-stores-data-for-reports.php 

Im not sure how do i upload the pbix in this community.can you help on that as well:-)

[negi007]

@Anonymous 

It is workly prefectly fine for me.

Below is powerbi Screenshot

[Anonymous]

I have a date table created in power bi with the help of DAX

Under relationship when i check i could see that i had connected Fact table

Ship date with Date table which was throwing wrong result

However im still trying to understand why did it try to throw wrong result but the total was correct ?

[negi007 · Accepted solution]

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