Monday, February 13, 2023

Create a Calendar Table From Date to Today

When you’re analyzing data where you’ve got dates, sometimes it’s a good idea to create a calendar table that not only has a date, but single column fields for the year, month or day of week. It helps then to show more detailed in your data. You can create one directly in the Excel worksheet with functions or you can use Power Query to make it more dynamic like creating a rolling calendar to auto populates with the current date. Creating a calendar table is not that hard and it’s useful information to help you do some additional analysis if you’re comparing dates or want to do some date grouping in a more granular way. It’s takes little time to set up and it’ll be useful in the long run.

No comments:

Post a Comment