Hi Alison,

The Index column numbers the days in your Calendar table, it's optional. If you don't need it then I'd leave it out.

Session 4.21 explains the options for sharing/reusing queries.

In regards to the dates being 5 years in front of today's date, do you mean the last date in the table is 5 years from today, or do you want to increase all dates in your table by 5 years?

I should point out that it's not a good idea to store data in your workbook that isn't yet required, so unless you're storing 5 years worth of forecast data then I wouldn't advise extending your dates 5 years from today.

Mynda

The dates to be 5 years in advance.   So my date table starts at 1/1/15 and will run to 15/12/2023

Re index column.  Why would I need it?  What scenarios would it be used in?

Hi Alison,

There are various examples of the Index column being used throughout the Power Query course. If you have further questions on Index columns once you've completed the course please let me know.

You can use the Date.AddYears function to add 5 years to your Max date.

Mynda

Looking at the solution you have sent for my previous version question the calendar table in there starts with a Min Max. date from the source data.

Is this a technique you would recommend to keep the date table only populated with the date range of the source?   or is there a downside to this?   

Yes, and variables are covered later in the Power Query course. There is no downside.