0

I am facing a weird problem. In my .pbix file, i have a date table and a main table. I have calculated "year wise count" in both Power BI and excel. But the problem is that, the numeric figure of the power bi file is not getting matched with the excel file's numeric figure.

I am attaching both power bi and excel file screenshots for better understanding.

Power Bi file

Excel File

I have imported the same CSV file into the power bi which i have analyzed into excel. yes, I was getting some error when i imported into the power bi, I removed those error from query editor.

so, is that the effect of getting low count than excel? or for the other reason? Can any Power Bi guy help me out what problem is that?

Please help me to solve this problem.This is a weird kind of situation I have been facing.

Monthly Data

Power Bi file

Excel file

Ron Rosenfeld
  • 53,870
  • 7
  • 28
  • 60
Sayan analytics
  • 21
  • 1
  • 4
  • Probably would have been smart to show the formulas you used; even if you simply left the active cell on one of the counts so we could view the formula in the formula bar. –  Feb 08 '18 at 08:45
  • 1
    @sayan your total is matching up. Only the year totals are not matching. So if you are using the date field directly in the BI and Excel Pivot there is a change of getting difference. Try to split the Years into separate column and then do Pivot – Praveen DA Feb 08 '18 at 09:16
  • @PraveenRKaruppannan Thanks a lot for your comment but, your idea not working.. – Sayan analytics Feb 08 '18 at 09:40
  • @Sayananalytics is there any way that we can sample of data – Praveen DA Feb 08 '18 at 09:49
  • @PraveenRKaruppannan The sample data is too large and this is client data.In spite of that I am trying.. – Sayan analytics Feb 08 '18 at 09:57
  • @Sayananalytics the problem should be with December data if your system time format and Power BI server format are different – Praveen DA Feb 08 '18 at 10:07
  • @PraveenRKaruppannan, I have added monthly data also..Please check it once.. – Sayan analytics Feb 08 '18 at 10:40
  • @Sayananalytics for testing just take 2014 Feb data in excel and 2014 Feb data in Power BI and compare the date column (it would be less as its 13 records). find the missing 2 records in power BI and check the date Column – Praveen DA Feb 08 '18 at 10:45
  • @PraveenRKaruppannan I am going through your idea..can you please provide your gmail id. because extending discussion over here is little more embarrassing. Mu mail id is: sanalytics2018@gmail.com.. – Sayan analytics Feb 08 '18 at 11:35
  • I'm voting to close this question as off-topic because sufficient data to reproduce the problem has not been supplied. – Ron Rosenfeld Feb 08 '18 at 13:06

1 Answers1

0

Please check the time zone and set both excel and Power BI to same format.. I should fix the issue...

Praveen DA
  • 358
  • 4
  • 17