Note: This question-is part of a series of questions that present the same scenario. Each question-in the series contains a unique solution that might meet the stated goals. Some question-sets might have more than one correct solution, while others might…
HOTSPOT You have a query that uses a Microsoft Excel data source. The data source contains the following table. You need the data to appear as shown in the following table. What should you do? To answer, select the appropriate…
HOTSPOT You have the following tables. You need to create a new table that displays the top 10 customers by the total of SalesAmount. How should you complete the DAX formula? To answer, select the appropriate options in the answer…
HOTSPOT You open powerbi.com 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 selection is worth one point. Hot…
DRAG DROP You create a new app workspace. You add a user named User1 as a member of the workspace. User1 can edit content. You plan to create a report in an app workspace that uses data from a Microsoft…
DRAG DROP You have the following two tables: Subscriber (SubscriberID, EnrollmentDate, ServicePlan) Date (Date, Month, Week, Year) There is a relationship between Subscriber[EnrollmentDate] and Date [Date]. You plan to create a KPI for the number of subscribers enrolled in the…
DRAG DROP You have a Power BI model that contains tables named Sales and Date. Sales contains four columns named SalesAmount, OrderDate, SalesPerson, and OrderID. You need to create a measure to calculate the last 12 months of sales. You…
DRAG DROP You have three Power BI Desktop projects named Report1.pbix, Report2.pbix, and Report3.pbix that have the following characteristics: Report1.pbix contains a custom visualization. Report2.pbix implements row level security. Report3.pbix connects to a Microsoft SQL Server database by using DirectQuery.…
DRAG DROP You have a property named FactInternetSales used by several Power BI reports. The query is shown in the exhibit. (Click the Exhibit button.) You plan to create a bar chart showing the count of sales by year that…
DRAG DROP You are creating a work schedule for a retail store. You have the following data from a query named Schedule. You need to visualize the data as shown in the following exhibit. You add a matrix visualization, and…