PL-300 V1

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers . What should you do?A . In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column...

You have a sales system that contains the tables shown in the following table. The Date table is marked as a date table. DatelD is the date data type. You need to create an annual sales growth percentage measure. Which DAX expression should you use?A . SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR('Date'[DateID])B...

You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization . Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection...

You have the visual shown in the Original exhibit. {Click the Original tab.) You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.) What should you add to the visual?A . a measureB . a trendlineC . a forecastD . an Average lineView AnswerAnswer:...

You publish a report to a workspace named Customer Services. The report identifies customers that have potential data quality issues that must be investigated by the customer services department of your company. You need to ensure that customer service managers can create task lists in Microsoft Excel based on the...

You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&A. You have a table named Customer that has the following measure. Customer Count = DISTINCTCOUNT(Customer[CustomerID]) Users frequently refer to customers as subscribers. You need to ensure that the users can...

HOTSPOT You have a report page that contains the visuals 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. View AnswerAnswer: Explanation: Box 1: cross-filter...

You create the following step by using Power Query Editor. = Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"}) A row has a value of 21318 Lasalle Street in the AddressLine1 column . What will the value be when the step is applied?A . 1318B . 1319C . 21318 Lasalle StreetD . 21319 Lasalle StreetView AnswerAnswer: D...

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 not have a correct solution. After you...

HOTSPOT You need to create the Top Customers report. Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Graphical user interface Description...