Forum Discussion
Difference in excel data and power bi data
Anonymous Total will be same. But values under year is different due to using incorrect date field.
Community ChampionAnonymous 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.
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
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 ?