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
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 theFact_Sales
table in the Values Pane
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 butHands-on interactive exercise
Turn theory into action with one of our interactive exercises
