Creating a date table

Dimensional date tables are necessary to ensure that calculations, such as DAX time-intelligence functions, have all available dates. This ensures there are no gaps between dates, so you don't receive any errors while performing these calculations.

In this exercise you will create a delivery date table because we already have a date table for invoices. More specifically, you will create a date table that ranges from the minimum delivery date to the maximum delivery date.

If you need additional hints during any of the exercises, you can check out our cheat sheet with all DAX functions used in this and the Intermediate DAX course.