Free PL-300 Exam Braindumps
Microsoft Power BI Data Analyst Questions 131–135 (page: 28)

You are reviewing a Power BI data model.
You have a calculated table that has the following definition.
ProductList = INTERSECT ( ProductsGroupA, ProductsGroupB )
You need to identify the results of the DAX expression.
Which rows will be returned in ProductList?

HOTSPOT (Drag and Drop is not supported)
You have a Power BI tenant that contains a workspace. The workspace contains a dataset named datasetA.
You need to build a pivot table report in Microsoft Excel. The report must use datasetA as the data source. The solution must meet the following requirements:
• Ensure that the report can be refreshed to get the latest available data from the Power BI service.
• Ensure that all the visible data in datasetA is available for use in Excel.
What should you do to connect Excel to datasetA, and which element in datasetA will be incompatible with the Excel connection? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

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 answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:
• Due Date
• Order Date
• Delivery Date
You need to support the analysis of sales over time based on all the date foreign keys.
Solution: You create measures that use the USERELATIONSHIP DAX function to filter sales on the inactive relationship between the sales table and the date table.
Does this meet the goal?

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 answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:
• Due Date
• Order Date
• Delivery Date
You need to support the analysis of sales over time based on all the date foreign keys.
Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables. You create active relationships between the sales table and each date table.
Does this meet the goal?

You have a Power BI semantic model that contains item, price, and country data. The data is displayed in a report that uses filters.
You need to calculate the average item price for a given country. The solution must support the existing filters.
Which type of quick measure should you use?