Get startedGet started for free

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.

This exercise is part of the course

DAX Functions in Power BI

View Course

Exercise instructions

Visualize the quantity of orders delivered over time by creating a area chart.
  • Place the Delivery Date Key from the new table in the Axis pane
  • Place the Quantity from the Fact_Sales table in the Values Pane
,Place the Delivery Date Key from the new table in the Axis pane,Place the Quantity from the Fact_Sales table in the Values Pane,Drill down one level in the hierarchy by clicking the double arrow but

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise