Q61
Hotspot
HOTSPOT
You have a Power BI semantic model that contains three tables named Products, OrderHistory, and Date.
The Products table is a dimension table that contains the following columns:
1. ProductID
2. ProductName
The OrderHistory table is a fact table that contains the following columns:
1. OrderID
2. ProductID
3. OrderDate
The Date table is a dimension table that contains the following columns:
1. Year
2. Date
3. Week
4. Month
You need to define a relationship from Products to OrderHistory and from OrderHistory to Date.
Which cardinality should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct answer is worth one point.
Select the correct area(s) on the image.
