QUESTION: 73 Exam Topic: Question Set 2

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:

See Explanation section for answer.

Answer(s): A

Explanation:

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]

Reference:

https://dax.guide/totalytd/

Reveal Solution Next Question

QUESTION: 74 Exam Topic: Question Set 2

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: 75 Exam Topic: Question Set 2

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

Explanation:

Remove a column that is not used in the visuals reduces the size of the dataset.
Incorrect:
Not A: Merging the tables would increase the dataset.
Not C: Two of the visuals need historical data.
Not D: Grouping would not affect size.

Reveal Solution Next Question

QUESTION: 76 Exam Topic: Question Set 2

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

Explanation:

B: Only blog posts rows are useful for the visuals.
D: These two columns are not used in the visuals and can be removed.
Incorrect:
Not A: Three visuals need historical data.
Not C: Traffic[Referring URL] is used in one of the visuals and therefore cannot be removed.
Not E: These rows are used in 3 visuals.

Reveal Solution Next Question

Free PL-300 Exam Braindumps (page: 19)

QUESTION: 73 Exam Topic: Question Set 2

Explanation:

Reference:

QUESTION: 74 Exam Topic: Question Set 2

Explanation:

Reference:

QUESTION: 75 Exam Topic: Question Set 2

Explanation:

QUESTION: 76 Exam Topic: Question Set 2

Explanation: