When you're creating relationships between tables that have dates, it often useful to have a separate calendar table that references all the dates for the year or years that you need. It'll also be nice if it has extra fields or columns that give just the year, month or day name. You can often do this manually in Excel with a few functions, but if you wanted to make it auto-magically update based on your given start and end date, Power Query makes it much easier to do once you set it up.
No comments:
Post a Comment