You have the following tables.
There is a many-to-one relationship from Subscriber to Date that uses Subscriber[StartDate] and Date[Date]. The Cross filter direction of the relationship is set to Single.
You plan to create a column chart that displays the following two measures:
- Count of SubscriberID by Month based on the StartDate
- Count of SubscriberID by Month based on the EndDate
What should you do before you create the measures?
A. Create an active one-to-one relationship from Subscriber[StartDate] to Date[Date].
B. Change the Cross filter direction of the active relationship to Both.
C. Change the active relationship for many-to-one.
D. Create an inactive many-to-one relationship from Subscriber[StartDate] to Date[Date].
References:
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
D
It says there is only a relationship on StartDate, so don’t you need to create a in-active relationship on EndDate first?
1
2