Getting ready

To prepare for this recipe, do the following:

1. Open Power BI Desktop.
2. Import the data from the Ch09R05Data.xlsx Excel file located in this book's GitHub repository. Ensure that the created table is called R05_Table.

The R05_Table table contains a list of customer orders. Customer orders may have multiple line items and require multiple shipments to fulfill. The rows in the R05_Table table are at the line item level. Each line item includes the ordered amount (Ordered), shipped amount (Shipped), customer (Customer), and product segment (Segment), as well as when the customer expects the product (CustomerDueDate) and when the line item was actually delivered (DeliveredDate).