Excel file shows lower value than Power BI

[x-File]

Hi all,

See attached. I monthly compare Planned and realized values.

For january '23, there was apparantly some 2011 planned, and 1929 realized, according to the excel AND the left graph. This was the original. When I loaded the excel into another file, it showed 1996 and 1907. Went back to the excel, it showed 1996 and 1907 as well.

Now, for a test, I went to the original pbiox file, also loaded Table 1 (which is the same as Table 'Beds Comparison'), it shows 1996 and 1907. Though both tables in Query Editor contain the same values etc.

Could somebody help me? To make it more diffcult: 2011 and 1929 are the right values, though my excel doesn't show them.

I'm happy to email/add the files however this forum won't let me... 

Rgds,

Felix

[x-File]

HI @Arul , 

Could you please respond to my personal message to you? Thanks in advance!

Rgds,

Felix

[x-File]

   But could I email you? That would make it more eaey for the both of us I think?

[Arul]

@x-File ,

Where is that Beds Jan column?

Thanks,

Arul

[x-File]

It isn't in, it's what the file is called. I use the Totaal Column in Excel, or in power Bi a custom column that adds ochtend+middag+avond+nacht.

[x-File]

It can't. In my account, it doenst show your attached option somehow. Also, it shows this red bar when dragging something here. Could I email it?

 

[Arul]

@x-File ,

Share the screenshot of your data.

Thanks,

Arul

[Arul]

@x-File ,

Can you share the sample data file? refer the image where you can add your files while you are replying,

Thanks,

Arul