You are using Power Bi Desktop to connect to an Azure SQL database The connection is configured as shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic NOTE: Each correct solution is worth one point
You publish the dataset to powerbi.com.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
You have a Power BI model that contains a table named Sales. Sales has the following three measures:
* A measure named Total Sales Last Year that displays the sales from the previous calendar year. The current value is 32.89 million.
* A measure named Total Sales This Year that displays the sales from the current calendar year. The current value is 11.69 million.
* A measure named Total Sales Difference that uses a DAX formula of Sales[Last Year] - Sales[This Year].
You need to create the following visualization.
How should you configure the visualization? To answer, drag the appropriate measures to the correct fields.
Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
HOTSPOT
You have two tables named Customers and Invoice in a Power BI model.
The Customers table contains the following fields:
* CustomerID
* Customer City
* Customer State
* Customer Name
* Customer Address 1
* Customer Address 2
* Customer Postal Code
The Invoice table contains the following fields:
* Order ID
* Invoice ID
* Invoice Date
* Customer ID
* Total Amount
* Total Item Count
The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.
The Power BI model must provide the following information:
* The number of customers invoiced in each state last month
* The average invoice amount per customer in each postal code
You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.
What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)
You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).
You plan to use Power BI to import data from 2013 to 2015.
Product Subcategory [Subcategory] contains NULL values.
End of repeated scenario.
You implement the Power BI model.
You add another table named Territory to the model. A sample of the data is shown in the following table.
You need to create a relationship between the Territory table and the Sales table.
Which function should you use in the query for Territory before you create the relationship?
