Hi,
I created a date table in power pivot using 'design' date table; "new", fine,
the problem is when related to it's 'source' table in diagram view , the source table is on the one side and the Calendar table on the
many, the min date of the source is 05/05/2020 and the max is 17/01/2021.
The pivot table calendar has 731 rows? The first date is 01/01/2020 as you'd expect and the last 31/12/2021 again correct,
Where have the other rows come from , what's happening?
I've attached the example ;
Richad.
Bookmarks