You have sales data with a 'Ship Date' and an 'Order Date'. You want to calculate metrics based on both dates. What model design approach should you use?
-
A
Add two separate date tables and create inactive relationships to one
-
B
Use a single date table with two relationships, making one active and one inactive
-
C
Merge both date columns into one column in Power Query
-
D
Create two calculated columns that reference the single date table