In Power Query Editor, you have a query named Sales Data that contains the following columns.You need to create two queries named Product Dimension and Sales Fact based on the Sales Data query. The solution must minimize maintenance effort and the size of the dataset.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
Answer(s): A,E
You have a Power BI model that contains a table named Date. The Date table contains the following columns:• Date• Fiscal Year• Fiscal Quarter• Month Name• Calendar Year• Week Number• Month Number• Calendar QuarterYou need to create a calculated table based on the Date table. The calculated table must contain only unique combinations of values for Calendar Year, Calendar Quarter, and Calendar Month.Which DAX function should you include in the table definition?
Answer(s): C
HOTSPOT (Drag and Drop is not supported)You have a Power BI model that contains the following data.The Date table relates to the Sales table by using the Date columns.You need to create a calculated table that will contain the following:• A row for each year• A column that contains the total sales per yearHow should you complete the DAX calculation? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.
Answer(s): A
You use Power Query Editor to import and preview sales data from the years 2020 and 2021 in a Microsoft Excel file as shown in the following exhibit.You need to shape the query to display the following three columns:• Month• Sales• YearWhat should you select in Power Query Editor?
HOTSPOT (Drag and Drop is not supported)You are creating a Power BI model to analyze inventory.You load data into three tables named Date, Product, and Inventory. The Inventory table relates to the Date and Product tables by using one-to-many relationships.Inventory data is recorded daily with no exceptions. The correct inventory quantity for a given product in a month is the last recorded value for that month.You need to write a DAX measure that will show the correct inventory value when a user analyzes inventory by year, month, or date.How should you complete the measure? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.
Post your Comments and Discuss Microsoft PL-300 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the PL-300 content, but please register or login to continue.