PL-300

HOTSPOT You are enhancing a Power BI model that has DAX calculations. You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year. Which DAX functions should you use? To answer, select the appropriate options in the answer area. NOTE:...

You have a query that returns the data shown in the following exhibit. You need to configure the query to display the data as shown in the following exhibit. Which step should you use in the query?A . =Table.ExpandListColum(Table.TransformColunins(Source, {{"classes". Splitter.SplitTextByDelimiter('','', QuoteStyle.None), let itemType - (type nullable text) meta [Serialized.Text...

DRAG DROP You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones. You need to build the dashboard. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer...

You need to provide a solution to provide the sales managers with the required access. What should you include in the solution?A . Create a security role that has a table filter on the Sales_Manager table where username = UserName()B . Create a security role that has a table filter...

You have the dataset shown in the following exhibit. You need to ensure that the visual shows only the 10 cities that have the highest sales profit. What should you do?A . Add a Top N filter to the visual.B . Configure the Sales Profit measure to use the RANKX...

HOTSPOT You have a Power BI report. You need to create a calculated table to return the 100 highest spending customers. How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box...

DRAG DROP You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones. You need to build the dashboard. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer...

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is...

DRAG DROP You need to create a DAX measure in the data model that only allows users to see projections at the appropriate levels of granularity. How should you complete the measure? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than...

You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR...