70-778 Analyzing and Visualizing Data with Microsoft Power BI

Loading demo links...

Showing 10–10 of 10 questions

Question 10

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?

Select an option, then click Submit answer.

  • Create an active one-to-one relationship from Subscriber[EndDate] to Date[Date].

  • Change the Cross filter direction of the active relationship to Both.

  • Change the active relationship to many-to-one.

  • Create an inactive many-to-one relationship from Subscriber[EndDate] to Date[Date].