Forum Discussion
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...
Anonymous Total will be same. But values under year is different due to using incorrect date field.
negi007
Community Champion
Community ChampionAnonymous
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 ?
- negi007
Anonymous Total will be same. But values under year is different due to using incorrect date field.