Notifications
Clear all
Topic starter
06/10/2022 1:31 am
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
Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id] to ShipDate[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]
- E . 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 Sales[sales_ship_date_id]
Suggested Answer: A
Explanation:
Scenario: The customer service department requires a visual that can be filtered by both sales month and ship month independently.
Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
Explanation:
Scenario: The customer service department requires a visual that can be filtered by both sales month and ship month independently.
Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand