From the course: Excel Business Intelligence: Power Query

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create a rolling calendar with Power Query

Create a rolling calendar with Power Query - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Power Query

Start my 1-month free trial

Create a rolling calendar with Power Query

“

- [Instructor] Alright. Another pro tip coming at you. This one's creating a rolling calendar. So, one thing you might have noticed is in the last lecture, create a calendar, that was great. The thing is, we had a very concrete set of dates. We had two specific years worth of data. Which is fine if you're doing like a one time ad hock analysis, but what if you're revisiting this analysis or constantly adding new data? Things like running reports that happen on a monthly or quarterly or even weekly basis. And the last thing you want to do is have to constantly be updating your calendar table or loading up a calendar that goes way, way out into the future so you don't have to think about it. There's a more elegant way to deal with that and it's actually using a little custom bit of em code. Again, you can disregard this if it's not relevant to you, but if this is something that you do need, this is a really great solution. So I'm going to breeze through the five steps to do it. I'm…

Contents