You need to create a measure that will return the percentage of late orders.
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.

Correct Answer:

Explanation:

Box 1: CALCULATE
CALCULATE evaluates an expression in a modified filter context.
Syntax: CALCULATE(<expression>[, <filter1> [, <filter2> [, ...]]])
Expression - The expression to be evaluated.
filter1, filter2,... (Optional) Boolean expressions or table expressions that defines filters, or filter modifier functions.
Box 2: FILTER
FILTER returns a table that represents a subset of another table or expression.
Syntax: FILTER(<table>,<filter>)
Table- The table to be filtered. The table can also be an expression that results in a table.
Filter - A Boolean expression that is to be evaluated for each row of the table. For example, [Amount] > 0 or
[Region] = "France"
Box 3: Orders[ShippedDate]> Orders[RequiredDate]
Northwind Traders defines late orders as those shipped after the required shipping date.
Reference:
https://docs.microsoft.com/en-us/dax/calculate-function-dax
https://docs.microsoft.com/en-us/dax/filter-function-dax

Comment: *

Name: *

Email: *

Verification: *

You have a CSV file that contains user complaints. The file contains a column named Logged.
Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
What should you do?

• A.Split the Logged column by using at as the delimiter.
• B.Apply the Parse function from the Date transformations options to the Logged column.
• C.Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
• D.Change the data type of the Logged column to Date.

Comment: *

Name: *

Email: *

Verification: *

You are modifying a Power Bi model by using Power Bl Desktop.
You have a table named Sales that contains the following fields.

You have a table named Transaction Size that contains the following data.

Correct Answer:

Explanation

Comment: *

Name: *

Email: *

Verification: *

You have a dataset named Pens that contains the following columns:
Unit Price
Quantity Ordered
You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity.
Which type of visualization and which feature should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter

Comment: *

Name: *

Email: *

Verification: *

You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications. What should you do?

• A.Share the dashboard to the user.
• B.Create a subscription.
• C.Create a data alert.
• D.Tag the user in a comment.

Comment: *

Name: *

Email: *

Verification: *