From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Build a date table

Build a date table - Power BI Tutorial

From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press

Start my 1-month free trial Buy for my team

Build a date table

“

- [Instructor] Okay, so what we're going to do in this sub lesson is we are going to go ahead and build ourselves a date table in our model. And one of the main reasons we're doing this is we want to be able to take advantage of what are some of the most useful and interesting functions inside of Docs. And those are the time intelligence functions. So to do this, what we're going to do is I'm going to go to the table view and I'm going to click on table tools, click on new table. I will be presented with the formula bar looking like this. This time it says table equals 'cause now it's reminding me that we're going to go ahead and create a table. And what I'm going to do is I'm going to create a table with the name, "Order Date". And the way we're going to create this table is we're going to use the calendar function inside of Docs and it takes two parameters. The first parameter is a start date and the second one is an end date. So the way that we want this to work is we want to build…

Contents