What should be my Date range in the dCalendar table?

[mrxlsx]

Hello all,

This is a cross-post from Chandorg where it attracted almost nobody.

This is a PowerPivot question.

I have Fact table and couple of dim tables. In my Fact table I have my sales DATE range from 01-Jan-2008 TO 31-Dec-2014 in the OrderDate column.

Where as in my ShipDate column this range starts from 01-Jan-2008 TO anywhere 80+/- days +31-Dec-2014, where as another dim Table's Date column starts from 30+/-days of 01-Jan-2008 TO 180+/- days of 31-Dec-2014.

What should be my dCalendar table's date range start from and end till??

Thanks

 

[ralliartur]

In Excel 2010 use Power Query to transform the data and choose connection only as Load method, then go to Power Pivot window and choose Design tab -> Existing connections -> workbook connections

 

[TimRodman]

Thanks Ralliartur!

 

[mrxlsx]

Tim,

I didn't even find a way to download and install Power Query for Office 2010. I could not find the right link. You have got any way for that, Tim?
Can you share that?

Mine is Office 2010 Pro Plus 32bit

 

[TimRodman]

Ah, it looks like it's the same download for both:
https://www.microsoft.com/en-us/download/details.aspx?id=39379

Look at the System Requirements section and you'll see what I mean.