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 DateYou 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 active relationship between the sales table and the date table.Does this meet the goal?
Answer(s): B
HOTSPOT (Drag and Drop is not supported) You have a Power BI report that contains a measure named Total Sales.You need to create a new measure that will return the sum of Total Sales for a year up to a selected date.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.Hot Area:
Answer(s): A
Box 1: TOTALYTD TOTALYTD evaluates the specified expression over the interval which begins on the first day of the year and ends with the last date in the specified date column after applying specified filters.Syntax: TOTALYTD (<Expression>,<Dates>[, <Filter>][, <YearEndDate>]Expression - The expression to be evaluated.Dates - The name of a column containing dates or a one column table containing dates.Example:TOTALYTD ( -- 2007-01-01 : 2007-05-12[Sales Amount],'Date'[Date]Box 2: 'Date'[Date]
https://dax.guide/totalytd/
DRAG DROP (Drag and Drop is not supported) You are modifying a Power BI model by using Power BI Desktop.You have a table named Sales that contains the following fields.You have a table named Transaction Size that contains the following data.You need to create a calculated column to classify each transaction as small, medium, or large based on the value in Sales Amount.How should you complete the code? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all.You may need to drag the split bar between panes or scroll to view content.NOTE: Each correct selection is worth one point.Select and Place:
Box 1: CALCULATE CALCULATE evaluates an expression in a modified filter context.Syntax: CALCULATE(<expression>[, <filter1> [, <filter2> [, ג€¦]]])The expression used as the first parameter is essentially the same as a measure.Filters can be:Boolean filter expressions Table filter expressions Filter modification functions Table filter expression A table expression filter applies a table object as a filter. It could be a reference to a model table, but more likely it's a function that returns a table object. You can use the FILTER function to apply complex filter conditions, including those that cannot be defined by a Boolean filter expression.Box 2: AND Box 3: FILTER FILTER returns a table that represents a subset of another table or expression.Syntax: FILTER(<table>,<filter>)Note: DISTINCT returns a one-column table that contains the distinct values from the specified column. In other words, duplicate values are removed and only unique values are returned.
https://docs.microsoft.com/en-us/dax/calculate-function-daxhttps://docs.microsoft.com/en-us/dax/filter-function-dax
You have a Power BI report for the procurement department. The report contains data from the following tables.There is a one-to-many relationship from Suppliers to LineItems that uses the ID and Supplier ID columns.The report contains the visuals shown in the following table.You need to minimize the size of the dataset without affecting the visuals.What should you do?
You have a Power BI report for the marketing department. The report reports on web traffic to a blog and contains data from the following tables.There is a one-to-many relationship from Posts to Traffic that uses the URL and URL Visited columns.The report contains the visuals shown in the following table.The dataset takes a long time to refresh.You need to modify Posts and Traffic queries to reduce load times.Which two actions will reduce the load times? Each correct answer presents part of the solution.NOTE:Each correct selection is worth one point.
Answer(s): B,D
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.