I'm answering the LAB 1 Q1 but I get wrong answer for Dates and Sales row count. What I see is Date: 6209 and Sales: 10.439.386. Are these values are really wrong or is there something else? Can you confirm ?
It would appear that you didn't apply the filter so that only dates after Dec 31st, 1999 are included. Can you check if in your data there are rows with dates before year 2000? If so, the filters were not applied correctly
What steps are you taking to get this value? I just imported the Access database, selected bi_date and bi_salesFact, then clicked on Edit (not load). Then apply the filter as in the screenshots.
After this, click Close & Apply and the data will load. Then click on the Data tab and look at the row count in the bottom left to get the totals.
Sam Lester (MSFT)
Hi, i have filtered date after 12/31/1999 in bi_salesFact. However, i do not see any data row after that. The table seems empty. Is it something wrong with the source file? I tried filtering in Date query - filtered date after 12/31/1999 there is data.