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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
