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...
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.
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.