QUESTION: 93

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:

See Explanation section for answer.

Answer(s): A

Explanation:

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.

Reference:

https://docs.microsoft.com/en-us/dax/calculate-function-dax
https://docs.microsoft.com/en-us/dax/filter-function-dax

Reveal Solution Next Question

QUESTION: 94

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?

Merge Suppliers and LineItems.
Remove the LineItems[Description] column.
Remove the rows from LineItems where LineItems[Invoice Date] is before the beginning of last month.
Group LineItems by LineItems[Invoice ID] and LineItems[Invoice Date] with a sum of LineItems[Price].

Answer(s): B

Reveal Solution Next Question

QUESTION: 95

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.

Remove the rows in Posts in which Posts[Publish Date] is in the last seven days.
Remove the rows in Traffic in which Traffic[URL Visited] does not contain ג€blogג€.
Remove Traffic[IP Address], Traffic[Browser Agent], and Traffic[Referring URL].
Remove Posts[Full Text] and Posts[Summary].
Remove the rows in Traffic in which Traffic[Referring URL] does not start with ג€/ג€.

Answer(s): B,D

Reveal Solution Next Question

QUESTION: 96

HOTSPOT (Drag and Drop is not supported)
You are creating a quick measure as shown in the following exhibit.
You need to create a monthly rolling average measure for Sales over time.
How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.