CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. PL-300

Free PL-300 Exam Braindumps (page: 24)

Page 23 of 85
PDF with 356 Questions

You are building a data model for a Power BI report.
You have data formatted as shown in the following table.
You need to create a clustered bar chart as shown in the following exhibit.
What should you do?

  1. From Power Query Editor, split the Machine-User column by using a delimiter.
  2. From Power Query Editor, create a column that contains the last three digits of the Machine-User column.
  3. In a DAX function, create two calculated columns named Machine and User by using the SUBSTITUTE function.
  4. In a DAX function, create two measures named Machine and User by using the SUBSTITUTE function.

Answer(s): A



DRAG DROP (Drag and Drop is not supported)
You need create a date table in Power BI that must contain 10 full calendar years, including the current year.
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.
Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:


Box 1: YEAR
Get the current year.
Box 2: TODAY
TODAY returns the current date.
Box 3: CALENDAR
CALENDAR returns a table with a single column named ג€Dateג€ containing a contiguous set of dates. The range of dates is from the specified start date to the specified end date, inclusive of those two dates.
The following formula returns a table with dates between January 1st, 2005 and December 31st, 2015.
CALENDAR (
DATE ( 2005, 1, 1 ),
DATE ( 2015, 12, 31 )


Reference:

https://dax.guide/calendar/



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 active relationship between the sales table and the date table.
Does this meet the goal?

  1. Yes
  2. No

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:

  1. 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/






Post your Comments and Discuss Microsoft PL-300 exam with other Community members:

PL-300 Exam Discussions & Posts