PL-300 V4

What should you do to address the existing environment data concerns?A . a calculated column that uses the following formula: ABS(Sales[sales_amount]) B. a measure that uses the following formula: SUMX(FILTER('Sales', 'Sales'[sales_amount] > 0)),[sales_amount]) C. a measure that uses the following formula: SUM(Sales[sales_amount]) D. a calculated column that uses the following...

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...

DRAG DROP You create a data model in Power BI. Report developers and users provide feedback that the data model is too complex. The model contains the following tables. The model has the following relationships: * There is a one-to-one relationship between Sales_Region and Region_Manager. * There are more records...

You have a Power BI report that contains one page. The page contains two line charts and one bar chart. You need to ensure that users can perform the following tasks for all three visuals: ✑ Switch the measures used in the visuals. ✑ Change the visualization type. ✑ Add...

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...

DRAG DROP You create a data model in Power BI. Report developers and users provide feedback that the data model is too complex. The model contains the following tables. The model has the following relationships: * There is a one-to-one relationship between Sales_Region and Region_Manager. * There are more records...

HOTSPOT You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer area....

What is the minimum number of Power BI datasets needed to support the reports?A . a single imported dataset B. two imported datasets C. two DirectQuery datasets D. a single DirectQuery datasetView AnswerAnswer: A

What should you create to meet the reporting requirements of the sales department?A . a measure that uses a formula of SUM (Sales [sales_id]) B. a calculated column that use a formula of COUNTA(sales [sales_id]) C. a measure that uses a formula of COUNTROWS (Sales) D. a calculated column that...

You have the following table named Location. The GeoCode column represents the country where each customer is located. You create a map visualization as shown in the exhibit. (Click the Exhibit tab.) You need to ensure that the map displays the country locations. What should you do?A . Replace the...