Date Calendar Power Query

We start with power query editor and a column that has dates looking at the dates you will notice that they occur somewhere between 2010 and 2022.

Date calendar power query. List dates start date duration days end date start date 1 duration 1 0 0 0. In excel it depends on the version you have. Now instead of a series from 1 to 5 the challenge is to get a data range from 01 01 2018 till 31 12 2019.

Of course you may have a different date format. The fastest way i ve seen to create a dates table in power query is to start with the one line statement shown below which we ll put in a blank query. Office 365 versions and excel 2019.

Personally i prefer power query. Calendar query for this query we use the data get data combine queries merge command. This would be a lot easier and neater in power query in my view.

Create a list of 5 values starting from new year s eve date 2011 12 31 incrementing by. Just put this in the formula bar. To add some extra tricks to exercise.

In this article syntax list dates start as date count as number step as duration as list about. Now lets create a calendar from this column. Enter a start date the number count of days you want and the granularity of the calendar step 1 means daily and press ok.

Fill in the formula 01 01 2018 31 12 2019 this creates a list with two values. Make a new blank query name it parameters. Note how power query gives you some help about the function you just typed in.