What should you do before you create the report?

You have a Microsoft Excel 2016 workbook that has a Power Pivot model. The model contains the following tables
• Product (Produc_id, Product_Name)
• Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount)
• Salesperson (Salesperson_id, Salesperson_name, address)
The model has the following relationships:
• Sales to Product
• Sales to Salesperson
You create a new Power BI file and import the Power Pivot model.
You need to ensure that you can generate a report that displays the count of products sold by each salesperson. What should you do before you create the report?
A. Create a one-to-one relationship between Product and Salesperson.
B. For each relationship, change the Cross filter direction to Both.
C. For each relationship, change the Cardinality to One to one (1:1).
D. Change a many-to-one relationship between Product and Salesperson.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.