You need to create relationships to meet the reporting requirements of the customer service department.
What should you create?
A. an additional date table named ShipDate, a one-to-many relationship from Date[sales_date_id] to Sales[date_id], and a one-to-many relationship from ShipDate[sales_ship_date_id] to Sales[date_id]
B. an additional date table named ShipDate, a many-to-many relationship from Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]
C. a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]
D. a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many relationship from Sales[sales_ship_date_id] to Date[date_id] Correct Answer: A Section: (none) Explanation
Explanation/Reference:
Scenario: The customer service department requires a visual that can be filtered by both sales month and ship month independently.
In Power BI Desktop, only one relationship can be active between a Fact table and Dimension table, so we need an extra table.
Use one-to-many relationship to be able to filter.
Incorrect Answers:
C: Cannot make a relation between a date_id and a week_id.
D: The one-to-many relationships between the Sales and the Date tables goes in the other direction: for each date there can be many sales or shipments.
Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
[/showhide]
