Expanding the Date table

In our previous lessons, we discussed the importance of having a well formatted Date table. A Date table has already been created using the CALENDAR() function that takes in two arguments.

For our Date table, we have generated dates from the first order date to the latest order date. Some columns have already been created, but we are going to expand on this by creating new columns using date and text functions to work out which day of the week a particular day is.

This exercise is part of the course

Introduction to DAX in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise