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 SubscriberlD by Month based on the StartDate
• Count of SubscriberlD 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].
I think D is correct answer. After creating inactive we can use userrelationship dax function to achieve required result.
Correct me if i am wrong
sorry D is not correct answer. I read options wrong . I thought there is end date in place of start date in option D.
My mistake