| Exam Name: | Microsoft Power BI Data Analyst | ||
| Exam Code: | PL-300 Dumps | ||
| Vendor: | Microsoft | Certification: | Microsoft Certified: Power BI Data Analyst Associate |
| Questions: | 464 Q&A's | Shared By: | delilah-rose |
You need to minimize me size of the dataset. The solution must meet the report requirements What should you do?
Options:
Change lite OrderlD column in the Orders table to the text data type.
Filter out discontinued products while importing the Product table.
Remove the QuantityPerUnit column from the Products table
Group the Categories table by the CategorylD column.
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.
Options:
Answer:
Explanation:
Box 1: CALCULATE
CALCULATE evaluates an expression in a modified filter context.
Syntax: CALCULATE(
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(
